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
How can we remove the duplicates from flat file source?
What is Data Caches size?
What is the function of aggregator transformation?
Explain pushdown optimization and types in informatica
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Slowly changing dimensions, types and where will you use them
What does reusable transformation mean?
without table how to come first record only in oracle?
What is informatica?
What are the guidelines to be followed while using union transformation?
During the running session, output files are created by informatica server. Enlist few of them.
What is the use of code page?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is main use of mapplet?
What do you mean incremental aggregation?