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
What is a filter transformation and why it is an active one?
Why update strategy and union transformations are active? Explain with examples.
can u give example for factless fact table
Explain what are the different types of transformation available in informatica.
Define Pmrep command?
What do mean by local and global repository?
How can we use mapping variables in informatica?
How many numbers of sessions can one group in batches?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is the session task and command task?
what is song in infrmatica...?
What is target load order?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Enlist the differences between database and data warehouse.
What are the performance considerations when working with aggregator transformation?