Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11155 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 workflow monitor?
Explain how to import oracle sequence into informatica?
What is the benefit of partitioning a session?
What is a code page?
Where can we find the throughput option in informatica?
Define mapplet?
What is sequence generator transformation in informatica?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are junk dimensions?
What is joiner transformation in informatica?
What is informatica?
How do you change a non-reusable transformation to reusable transformation?
tell me about your project functionality
how to load rows into fact table in data warehouse
