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 different between the data warehouse and data mart?
Plz can any one say me how to get the informatica certification materials and dumps
How can we update a record in the target table without using update strategy?
tell me about your project functionality
define galaxy repository in informatica
How to extract the informatica rejected data?
How to create a non-reusable instance of reusable transformations?
Explain target update override in informatica
What is a difference between complete, stop and abort?
What can we do to improve the performance of informatica aggregator transformation?
What are the designer tools for creating transformations?
draw informatica architecture 8.6 ?
can we override a native sql query within informatica? Where do we do it?
What is primary and backup node?
What is union transformation?
