How to load duplicate records in to a target table which
has a primary key?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jay
Is that primary key column in the target is different,
than this is called surrogate key which is obtained
from Sequential generator (with or without combination of
key value from source. if combined with source primary key
column, then it is known as creating frequency for
each source primary column value)
| Is This Answer Correct ? | 4 Yes | 2 No |
Define Incremental Aggregation?
What are the differences between source qualifier and joiner transformation?
Issue with Update override at Target table in Informatica.
i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What will be the approach?
How to recover the standalone session?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
Can you use one mapping to populate two tables in different schemas
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
What do you understand by a term domain?
What are the popular informatica products?