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 is option by which we can run all the sessions in a batch simultaneously?
What is pmcmd command?
How to use pmcmd utility command?
what is song in infrmatica...?
What are batches?
What is union transformation?
Why sorter is an active transformation?
What are the different options available for update strategy?
What are the different transaction levels available in transaction control transformation?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is target load order?
Explain the etl program with few examples.
Briefly describe lookup transformation?
What is different between the data warehouse and data mart?