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
How we can create indexes after completing the loan process?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is olap (on-line analytical processing?
Which is the t/r that builts only single cache memory?
Mention some types of transformation?
Which version configuration tool used in ur project?
Explain constraint based loading in informatica
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What are connected or unconnected transformations?
Do you find any difficulty while working with flat files as source and target?
What are the differences between source qualifier and joiner transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the databases that informatica can connect to windows?
What is meant by target load plan?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use