Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between warehouse key and surrogate key?
- 1 Answers
- 6761 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / jaspreet banga
Surrogate key concept:- Surrogate keys are generated by
system and they identifies unique 'ENTITY'! yes its entity
and not record ,while primary key is used for finding
unique record.
Let me give you a simple classical example for surrogate
key:
On the 1st of January 2002 Employee 'E1' belongs to
Business Unit 'BU1' (that's what would be in your Employee
Dimension). This employee has a turnover allocated to him
on the Business Unit 'BU1' But on the 2nd of June the
Employee 'E1' is muted from Business Unit 'BU1' to Business
Unit 'BU2.' All the new turnover have to belong to the new
Business Unit 'BU2' but the old one should Belong to the
Business Unit 'BU1.'
If you used the natural business key 'E1' for your employee
within your datawarehouse everything would be allocated to
Business Unit 'BU2' even what actualy belongs to 'BU1.'
If you use surrogate keys you could create on the 2nd of
June a new record for the Employee 'E1' in your Employee
Dimension with a new surrogate key.
This way in your fact table you have your old data (before
2nd of June) with the SID of the Employee 'E1' 'BU1.' All
new data (after 2nd of June) would take the SID of the
employee 'E1' 'BU2.'
You could consider Slowly Changing Dimension as an
enlargement of your natural key: natural key of the
Employee was Employee Code 'E1' but for you it becomes
Employee Code Business Unit - 'E1' 'BU1' or 'E1' 'BU2.' But
the difference with the natural key enlargement process is
that you might not have all part of your new key within
your fact table so you might not be able to do the join on
the new enlarge key -> so you need another id.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What are the components of the workflow manager?
what is the Default Source Option For Update Strategy Transformation?
where to store informatica rejected data? How to extract the informatica rejected data?
Explain about Informatica server process that how it works relates to mapping variables?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is primary and backup node?
What is a repository? And how to add it in an informatica client?
What are the types of data warehouses?
What is the need for an etl tool?
what is informatica metadata?
How do you load alternate records into different tables through mapping flow?
What is a sorter transformation?
When do you use sql override in a lookup transformation?
Could you explain what is enterprise data warehouse?
