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
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.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How does a sorter cache works?
What is pmcmd command?
What are the types of schemas we have in data warehouse and what are the difference between them?
What does “tail –f” command do and what is its use as an Informatica admin.
difference between repository database and repository service?
What is exclusive and normal mode for repository services?
What are the different options available for update strategy?
What are the different types of olap? Give an example?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Why is sorter an active transformation?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the difference between informatica 7.0 and 8.0?