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
Define mapplet?
Did u used latest transformations of 8.6.0? for what?
can you please explain me pre session and post session options?
What is the use of transformation?
What is dimensional table?
To import the flat file definition into the designer where should the flat file be placed?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is enterprise data warehousing?
What are the uses of etl tools?
what is the difference between informatica6.1 and infomatica7.1
What is xml source qualifier transformation in informatica?
What does reusable transformation mean?
Which transformation is needed while using the Cobol sources as source definitions?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain where to store informatica rejected data? How to extract the informatica rejected data?