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
Explain informatica architecture - version 8 / 9
What are the different ways to implement parallel processing in informatica?
Enlist the tasks for which source qualifier transformation is used.
Define pmcmd command?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How you know when to use a static cache and dynamic cache in lookup transformation?
Can we create multiple integration service on single repository?
What is resilience time?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How many transformations can be used in mapplets.
Briefly define a session task?
How to join three sources using joiner? Explain though mapping flow.
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is deployment group?
Mention a few design and development best practices for informatica?
