How to load duplicate records in to a target table which
has a primary key?
Answer Posted / pradeeshkumar
Loading duplicate records into a target table which has a
primary key is just a height of Brain failure.
The concept of primary key itself fails. If you still want
to insert it, better don't have any primary key
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Differentiate between joiner and lookup transformation?
What is a surrogate key?
Describe data concatenation?
In informatica workflow manager, how many repositories can be created?
Differentiate between source qualifier and filter transformation?
What are the different components of powercenter?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
What are the types of presistent cache in look up tr.
Explain what is informatica metadata and where is it stored?
What are the different types of transformation available in informatica.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Define mapplet?
Is stop and abort are same in informatica?
Why union transformation is an active transformation?