Answer Posted / nivas
Surrogate key is a system generated sequence numbers. It is
also called artificial key.Sarrogate key using as a primary
key without using sarrogate key we can't do SCD type2
implemenation.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Different circumstance which drives informatica server to expel records?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
How do you manage the Parameter files while migrating your data from one environment to another environment?
Different qualification between a related rotate toward the sky and isolates look upward?
Differentiate between a database and data warehouse?
What are the different transaction levels available in transaction control transformation?
What is the surrogate key?
What is the format of informatica objects in a repository?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How to use pmcmd utility command?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is joiner change?
Explain the different dimensions.
What is aggregate cache in aggregator transformation?