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

Answer Posted / sujit

by the use of update strategy T/R we can insert new row and
updae a existing row on the time of T/R

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can one identify whether mapping is correct or not without connecting session?

1142


How do you load only null records into target?

937


How to open an older version of an object in the workspace?

827


What are the restrictions of union transformation?

774


what is the size of your data warehousing?

1845


What will be the approach?

748


What are the basic requirements to join two sources in a source qualifier transformation using default join?

799


What are the different versions of informatica?

925


What are the various types of transformation?

860


What are batches?

804


Explain where to store informatica rejected data? How to extract the informatica rejected data?

802


During the running session, output files are created by informatica server. Enlist few of them.

741


What are the different types of olap? Give an example?

750


Please let me know how to make Data masking in informatica..

1456


What do you mean by blocking transformation?

772