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
How to Create a folder using pmrep command?
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
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?
What is target designer and target load order?
Make a note of the quantity vaults made in informatica?
What are the popular informatica products?
How to join three sources using joiner?
Why union transformation is an active transformation?
Explain what transformation and how many are there in informatica?
In how many ways we can create ports?
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
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
Explain target update override in informatica
What are Dimensional table?
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.