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
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is a transaction control transformation?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is rank index in rank transformation?
can anyone explain me about retail domain project in informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What do you understand by SOA of Informatica?
update strategy transformation in informatica
What is a connected transformation?
Slowly changing dimensions, types and where will you use them
what is size of u r database?
Can you generate sequence numbers without using the sequence generator transformation?
Please let me know how to make encryption and decryption with example?
What is a router transformation?