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
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is resilience time?
explain abt ur project architecture?
What is a filter transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the differences between joiner transformation and source qualifier transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Briefly define reusable transformation?
What is the commit type if you have a transaction control transformation in the mapping?
What is the difference between Active and Passive transformation?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Parameter and variable differences
Enlist the advantages of informatica.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the different versions of informatica?