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 the benefit of session partitioning?
What are the tuning techniques you applied during your last project
Is it possible to use a client with different version than that of its Informatica server?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the Process to creating lookup transformation in informatica
When do you use sql override in a lookup transformation?
How will the document be delivered to me?
In how many ways we can create ports?
Tell me about Propagate functions in informatica
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the new features of Power Center 5.0?
Explain the different dimensions.
what are the Methods For Creating Reusable Transformations?
Explain the aggregator transformation?
Write the unconnected lookup syntax and how to return more than one column.
