without dynamic lookup transformation how to insert new
rows and update existing rows?

Answer Posted / vali

you can use source qualifier transformation to do this.
write join condition ...
the rest of the operation will be same

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we override a native sql query within informatica?

807


What is sequence generator transformation in informatica?

803


What you know about transaction control transformation?

745


Explain the shared cache and re-cache?

806


Where do we use mapping variables in informatica?

791


Mention few advantages of router transformation over filter transformation.

831


Explain how to import oracle sequence into informatica?

759


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1816


What is the function of aggregator transformation?

791


How can a transformation be made reusable?

835


What are the types of data warehouses?

1154


Which development components of informatica have the highest usage?

792


What is option by which we can run all the sessions in a batch simultaneously?

856


Explain sql transformation in script mode examples in informatica

788


Why union transformation is an active transformation?

848