Insert else update option in which situation we will use
Answers were Sorted based on User's Feedback
Answer / mike
as per my knowledge
when we use update strategy transformation we will come
across to use this...insert else update...
let us suppose we have two tables a and b. a is the source
table and b is the target table...let us take b which is
target table contains some matched records with 'a' which
is source table. If source table 'a' is modified and
inserted with some records,here we need to update the
records in the target table...therefore by using the insert
else update option in the session properties of target we
can insert new records and update the existing records
correct me if i was wrong
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / naveen
This option we use when we want to maintain the history.
if records are not availabe in target table then it inserts
the records in to target and records are available in
target table then it updates the records.
Regards,
Naveen
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
Clarify the utilization of aggregator cache record?
Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar
what is distinct
Different circumstance which drives informatica server to expel records?
4 yrs etl devloper roles and responsibilities?any body give solutions
Tell me about MD5 functions in informatica
What is lookup transformation?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
What are the components of workflow manager?
What are the settings that you use to configure the joiner transformation?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow