Answer Posted / sunil kumar singh
Surrogate Key is artificial that is created for
datawarehousing for generating the unique number for each
record. Surrogate key works on the behalf of primary key.
And main purpose of surrogate key is to maintain the
historical record.
| Is This Answer Correct ? | 15 Yes | 3 No |
Post New Answer View All Answers
Which version configuration tool used in ur project?
In informatica workflow manager, how many repositories can be created?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are the designer tools for creating transformations?
How do you update the records with or without using update strategy?
Is it possible to define a single node as a Gateway node as well as worker node?
How to improve the performance of a session using sorter transformation?
What is meant by pre and post session shell command?
How do we call shell scripts from informatica?
What are the transformations that are not supported in mapplet?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
write a query to retrieve the latest records from the table sorted by version(scd)
How to create a non-reusable instance of reusable transformations?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
how to load dimension table and fact table. plz tell me the steps.