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
Under which circumstances, informatica server creates reject files?
What is lookup transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Global and Local shortcuts. Advantages.
How do you migrate data from one environment to another?
What is the session task and command task?
Explain what are the different versions of informatica?
What are the reusable transformations?
Name the different lookup cache(s)?
tell me 5 session failure in real time how can you solve that in your project?
What is the sql query overwrite in source qualifier in informatica
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
State the limitations where we cannot use joiner in the mapping pipeline?
How to update a particular record in target with out running whole workflow?
How can you increase the performance in joiner transformation?