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 to Create a folder using pmrep command?

712


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1734


Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

645


What is target designer and target load order?

743


Make a note of the quantity vaults made in informatica?

655






What are the popular informatica products?

720


How to join three sources using joiner?

670


Why union transformation is an active transformation?

751


Explain what transformation and how many are there in informatica?

587


In how many ways we can create ports?

799


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

1849


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1780


Explain target update override in informatica

728


What are Dimensional table?

692


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

749