Answer Posted / obulreddy.b
IT IS A TRANSFORMATION WHICH IS USED TO PERFORM DML
OPERATIONS ON ALREADY DATA POPULATED TARGETS.
GENERALLY INFORMATICA SERVER WILL TREAT SOURCE ROWS AS
INSERT. IF WE USE UPDATE STRATOGY TRANSFORMATION WE HAVE TO
SELECT TREAT SOURCE ROWS AS DATADRIVEN IN SESSION
PROPERTIES, NOW INFORMATICA SERVER DRIVES THE DATA AS PER
UPDATE STRATOGY VALUE.
WE HAVE TO SELECT UPDATE STRATOGY VALUE BASED ON OUR
REQUIREMENT.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What do you mean by worklet?
While migrating the data from one environment to another environment how would you manage the connections?
Differentiate between Load Manager and DTM?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is expression transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are batches?
Which version configuration tool used in ur project?
What does role playing dimension mean?
How to create Target definition for flat files?
How to create a non-reusable instance of reusable transformations?
How do you migrate data from one environment to another?
In warehouses how many schemas are there?
Differentiate between router and filter transformation?
What is joiner transformation in informatica?