How to load duplicate records in to a target table which
has a primary key?
Answer Posted / jay
Is that primary key column in the target is different,
than this is called surrogate key which is obtained
from Sequential generator (with or without combination of
key value from source. if combined with source primary key
column, then it is known as creating frequency for
each source primary column value)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What are the differences between oltp and olap?
Is stop and abort are same in informatica?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Tell me about MD5 functions in informatica
Mention some types of transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the tasks that can be performed using sq?
What is difference between a gateway node and worker node?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain the mapping variable usage example in informatica
Explain sql transformation in script mode examples in informatica
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are different types of transformations available in informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project