Insert else update option in which situation we will use
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 is an expression transformation?
How many ways are there to create ports?
What do you mean by channel change?
How can we handle two sessions in informatica?
lookup transformation with screenshots
what is $$$$?
What is substr 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?
Difference between Target-based loading and constraint-based loading?
What is lookup change?
write a query to retrieve the latest records from the table sorted by version(scd)
How can informatica be used for an organization?
Which are the different editions of informatica powercenter that are available?
what is the difference between informatica6.1 and infomatica7.1
How to do the error handling of if ur source is flatfiles?