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
How to join three sources using joiner? Explain though mapping flow.
Which transformation should we use to normalise the COBOL and relational sources?
How we can create indexes after completing the load process?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
what is unit testing?tell me proceedure
What are the popular informatica products?
Briefly define a session task?
Slowly changing dimensions, types and where will you use them
How do you load first and last records into target table?
What is the maplet?
Whats there in global repository
Can we change Dynamic to Static or Persistent cache? If so what happens?
Explain the difference between mapping parameter and mapping variable?
Is there any target staging area in informatica not staging area
What is union transformation in informatica?