Insert else update option in which situation we will use
Answer Posted / madhavi
if the source table contain multiple records .if the record specified in the associated port to insert into lookup cache. it does not find a record in the lookup cache when it is used find the particular record & change the data in the associated port.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Define mapplet?
difference between repository database and repository service?
Do you find any difficulty while working with flat files as source and target?
how tokens will generate?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What could be the possible resons of locks by user?
What is transformation?
What is the Rank index port in Rank transformation?
What are data-driven sessions?
Which files are created during the session rums by informatics server?
Parameter and variable differences
What are the data movement modes in informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?