when source contains surrogate key instead of natural key
2 posters
Page 1 of 1
when source contains surrogate key instead of natural key
How to design dimension and facts when my source system table itself contains surrogate key (i mean auto generated id).......
for example:
EMP {
id PK
name
salary
designation
}
id is autogenerated sequence....... my dimension will contain this id as surrogate key but no natural key ...is it right?
if it is right then i cannot create key map table for my dimension
for example:
EMP {
id PK
name
salary
designation
}
id is autogenerated sequence....... my dimension will contain this id as surrogate key but no natural key ...is it right?
if it is right then i cannot create key map table for my dimension
huny- Posts : 5
Join date : 2013-03-24
Re: when source contains surrogate key instead of natural key
A natural key is what the business uses to identify an entity. If the business is using this auto-generated number as the employee ID, then that is the natural key. It doesn't matter where the value comes from. Assign a surrogate key as you would with any natural key.
Re: when source contains surrogate key instead of natural key
ngalemmo wrote:A natural key is what the business uses to identify an entity. If the business is using this auto-generated number as the employee ID, then that is the natural key. It doesn't matter where the value comes from. Assign a surrogate key as you would with any natural key.
Thank You so much
huny- Posts : 5
Join date : 2013-03-24
Similar topics
» SCD Type 1 and 2
» Surrogate vs natural keys and smart columns
» Hierarchy as Type 2 Change - Use Surrogate or Natural Key?
» SSIS 2008: Replacing Natural Keys With Surrogate Keys
» Non-durable natural keys
» Surrogate vs natural keys and smart columns
» Hierarchy as Type 2 Change - Use Surrogate or Natural Key?
» SSIS 2008: Replacing Natural Keys With Surrogate Keys
» Non-durable natural keys
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|