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


Please Help Members By Posting Answers For Below Questions

What are the types of caches in lookup?

782


Differentiate between a repository server and a powerhouse?

795


Explain the different dimensions.

739


Can we create a Integration service without a Repository service and vice versa?

989


What is a dimensional model?

752


In informatica workflow manager, how many repositories can be created?

1040


What do you understand by term role-playing dimension?

785


How to generate sequence numbers using expression transformation?

846


Difference between Data and Index Caches?

873


design of staging area?

1814


What is persistent lookup cache?

791


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1741


What is update strategy transform?

807


Can we create two repositories on same database instance in oracle?

849


What is the maplet?

809