• In the world of BI it is very common in dimensional design to know both the physical primary key of a target dimension table and the logical equivalent business key. With dimensions being denormailzed quite often, there maybe be a primary key from more than one source table that contributes to a composite logical primary key in the target dimension--this is also known as the alternate key as Jeff has pointed out.

    Hope it helps.....