Insert else update option in which situation we will use
- 4 Answers
- 10113 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 the difference between a repository server and a powerhouse?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Explain incremental aggregation in informatica
What are active and passive transformations?
Explain sessions?
Write the advantages of partitioning a session?
What does refresh system mean, and what are its distinctive choice?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is primary and backup node?
How do you use reject loader.
Where do we use mapping variables in informatica?
How many ways a relational source definition can be updated and what are they?
Can we create multiple integration service on single repository?
What are the data movement modes in informatica?
What are multi-group transformations?
