Insert else update option in which situation we will use
- 4 Answers
- 9794 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Parameter and variable differences
What is a pre-defined event and user-defined event?
What is informatica? Why do we need it?
Name the different lookup cache(s)?
How to Create a folder using pmrep command?
Quickly characterize reusable change?
What is the surrogate key?
What is the function of look up transformation?
what is $$$$?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is an aggregator transformation?
