How to load duplicate records in to a target table which
has a primary key?
Answer Posted / 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 |
Post New Answer View All Answers
wf dont have integration severances how you can run?
What could be the possible resons of locks by user?
Explain the use of aggregator cache file?
Target increases every day even though no new record was inserted
What are the types of caches in lookup? Explain them.
What is informatica worklet?
Enlist some properties of sessions.
How many numbers of sessions can one group in batches?
How do you handle two sessions in Informatica
Explain why we use partitioning the session in informatica?
How to elaborate powercenter integration service?
What are the tasks that source qualifier perform?
Explain about cumulative Sum or moving sum?
What is the procedure for creating independent data marts from informatica 7.1?
Write the program through which the records can be updated?