Insert else update option in which situation we will use
- 4 Answers
- 10454 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
How to load data in informatica ?
Describe the impact of several join conditions and join order in a joiner transformation?
Explain sessions. Explain how batches are used to combine executions?
What is a node in Informatica?
what is informatica metadata?
Explain lookup transformation in informatica
How to join three sources using joiner?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain about Informatica server process that how it works relates to mapping variables?
What is Cognos script editor?
How to create a non-reusable instance of reusable transformations?
What is data caches/ index caches?
What is informatica worklet?
How do you set a varible in incremental aggregation
What are the data movement modes in informatica?
