without dynamic lookup transformation how to insert new
rows and update existing rows?
Answer Posted / murali raju
Simple you can take one look up transformation give the
condition as empno=empno1(if it is primary key) and take
update strategy transformation just pass condition as
IIF(empno=empno1,dd_update,dd_insert). in this way we can
insert new records and update old records without keepimg
historical data.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we use mapping variables in informatica? Where do we use them?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is the difference between a connected look up and unconnected lookup?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What is the use of transformation?
How to handle decimal places while importing a flatfile into informatica?
Explain your project of banking domian.
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is InformaticaPowerCenter?
What is complex mapping?
How to improve the performance of a session using sorter transformation?
How to extract the informatica rejected data?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is a filter transformation?
What is a stored procedure transformation?