Interested to Buy Any Domain ? << Click Here >> for more details...
Insert else update option in which situation we will use
- 4 Answers
- 11352 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 extract sap data using informatica? What is abap? What are idocs?
Does an informatica transformation support only aggregate expressions?
Differentiate between source qualifier and filter transformation?
How to call shell scripts from informatica?
What is rank transformation in informatica
Difference between Target-based loading and constraint-based loading?
How can a transformation be made reusable?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is dimensional table?
What are the components of the workflow manager?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Describe expression transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
How do you change a non-reusable transformation to reusable transformation?
tell me 5 session failure in real time how can you solve that in your project?
