What is a surrogate key?Why we use it in a mapping?Pl give
an example.
Answer Posted / sanjay
Saradhi has given the perfect example of Surrogate key..
Thnx Saradhi
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How can we handle two sessions in informatica?
What do mean by local and global repository?
EXL informatica Questions
What is the difference between writing a joiner query in ANSI style and THETA style?
How to implement security measures using repository manager?
What are data-driven sessions?
Differentiate between Load Manager and DTM?
Global and Local shortcuts. Advantages.
what is diff b/t sorter t/r and agg have the option sorter property...
How can we create index after completion of load process?
Explain scd type 3 through mapping.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
generate date / time dimension in informatica
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Enlist the tasks for which source qualifier transformation is used.