Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajat singh
Surrogate key is the primary key for the Dimensional table.
Surrogate key is a substitution for the natural primary key.
Data warehouses typically use a surrogate, (also known as
artificial or identity key), key for the dimension tables
primary keys. They can use Infa sequence generator, or
Oracle sequence, or SQL Server Identity values for the
surrogate key.
It is useful because the natural primary key (i.e. Customer
Number in Customer table) can change and this makes updates
more difficult and also used in SCDs to preserve historical
data.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
When do you use sql override in a lookup transformation?
Where is metadata stored?
what are factless facts? And in which scenario will you use such kinds of fact tables.
permutations of mapplet
r u done any partitions in ur project?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is option by which we can run all the sessions in a batch simultaneously?
Differences between connected and unconnected lookup?
How to elaborate powercenter integration service?
How you prepared reports for OLAP?
What are the types of presistent cache in look up tr.
What are pre and post-session shell commands?
How many ways a relational source definition can be updated and what are they?
How to differentiate between the active and passive transformations?
How to use procedural logic inside infromatica?
