Answer Posted / kamesh
When ever a mapping contains Update Strategy Transformation
the way data needs to be treated is declared in the session
property as Data Driven. This is done by mentioning
DD_UPDATE or DD_INSERT or DD_DELETE in the update strategy
transformation.
A mapping may contain two Update strategy transformations,
1 for inserting and another for updating in two different
pipelines in single mapping.
Therefore, in order session to get executed successfully,
mention Data Driven property in the session properties for
that particular mapping.
| Is This Answer Correct ? | 23 Yes | 3 No |
Post New Answer View All Answers
What is deployment group?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How to join three sources using joiner? Explain though mapping flow.
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What will be the approach?
What is an unconnected transformation?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is depict expression change?
Explain sessions?
What is union transformation in informatica?
explain about unit testing? in real time?
What is the scenario which compels informatica server to reject files?
What is update strategy transform?
What is a filter transformation?
Where are the source flat files kept before running the session?
