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
What is the sequence generator transformation in informatica?
What is a sequence generator transformation?
can we override a native sql query within informatica? How do we do it?
Explain the features of connected and unconnected lookup.
What are roles and groups and benefits of using them?
What is a mapplet/worklet in informatica?
Where is metadata stored?
What is transformation?
Explain lookup transformation in informatica
How does a rank transform differ from aggregator transform functions max and min?
What is the function of look up transformation?
Which is the t/r that builts only single cache memory?
Explain the aggregator transformation?
What are the performance considerations when working with aggregator transformation?
What is the benefit of session partitioning?
