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 differences between a connected lookup and unconnected lookup?

643


How many number of sessions can one group in batches?

686


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1123


What is rank transformation?

572


What is data transformation manager process?

619






What are data-driven sessions?

713


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1616


What is the advantage of informatica?

643


Difference between Data and Index Caches?

649


What are the limitations of joiner transformation?

649


Explain what is informatica metadata and where is it stored?

604


How you can differentiate between connected lookup and unconnected lookup?

606


How to configure mapping in informatica?

674


Explain sessions and how many types of sessions are there?

578


how many types of dimensions are available in informatica?

559