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
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 the cumulative sum and moving sum?
How we can create indexes after completing the load process?
Explain your project of banking domian.
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Explain the types of transformations?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Differences between connected and unconnected lookup?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How can we improve session performance in aggregator transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What are mapplets? How is it different from a Reusable Transformation?
Please let me know how to make encryption and decryption with example?
What is main use of mapplet?
