Interested to Buy Any Domain ? << Click Here >> for more details...
How to load duplicate records in to a target table which
has a primary key?
- 2 Answers
- 7881 Views
- I also Faced
- E-Mail Answers
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 |
Three date formats are there . How to change these three into One format without using expression transformation ?
How to partition the Session?
what is mean by complex business rule ?
Name 4 output files that informatica server creates during session running?
how we can do session partition in informatica any one explain me clearly? thanks advance.
how to we create datamart?
What is critical mapping?
If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?
How can we delete duplicate rows from flat files?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
Teradata 
