without dynamic lookup transformation how to insert new
rows and update existing rows?
Answer Posted / bj
With out lookup and update st. transformation we can still
insert new and update data at session level.
in session at the time giving target table connect bottom u
find insert and update just check that box.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
can you please explain me pre session and post session options?
update strategy transformation in informatica
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the tasks that can be performed using sq?
How do you load unique records into one target table and duplicate records into a different target table?
What is the surrogate key?
What are the settings that you use to configure the joiner transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are connected or unconnected transformations?
what is the size of your data warehousing?
What are mapplets?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How we can create indexes after completing the load process?
What are the types of caches in lookup? Explain them.