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
Partition, what happens if the specified key range is shorter and longer
what is INFORMATICA TESTING process
What is dynamic cache?
Define the various join types of joiner transformation?
Difference between Data and Index Caches?
What is the maplet?
What is informatica etl tool?
Mention few power centre client applications with their basic purpose?
Differentiate between reusable transformation and mapplet.
What are the new features of informatica 9.x developer?
What is meant by pre and post session shell command?
How to generate sequence numbers?
What is the difference between a repository server and a powerhouse?
what are the deliverables?in your project?
What is informatica? Why do we need it?
