Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11501 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 is aggregate cache in aggregator transformation?
wf dont have integration severances how you can run?
Which are the different editions of informatica powercenter that are available?
What is the need for an etl tool?
What is Data Caches size?
What are the different options available for update strategy?
What is the use of source qualifier?
Explain the informatica workflow?
What are the informatica performance improvement tips
Can we create two repositories on same database instance in oracle?
design of staging area?
What is joiner change?
How to join three sources using joiner?
What are the differences between joiner transformation and source qualifier transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
