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
In development project what is the process to follow for an etl developer from day1
Explian the Process of deployment groups in informatica
What do you understand by SOA of Informatica?
have u done any performance tuning? how u ll do?
What do you mean incremental aggregation?
What are the differences between a connected lookup and unconnected lookup?
Can anyone tell me the new features in Informatica 9 Version?
What is informatica metadata and where is it stored?
Is it possible to create multiple domains on a single Informatica server?
What do you understand by a term domain?
What is a sequence generator transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How would you copy the content of one repository to another repository?
In warehouses how many schemas are there?
How to load the data from people soft hrm to people soft erm using informatica?