what is data driven in update strategy transformation?
Answer Posted / infa_geek
Integration Service follows instructions coded into Update
Strategy and Custom transformations within the session
mapping to determine how to flag rows for insert, delete,
update, or reject.
If the mapping for the session contains an Update Strategy
transformation, this field is marked Data Driven by
default.
If you do not choose Data Driven when a mapping contains an
Update Strategy or Custom transformation, the Workflow
Manager displays a warning.
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
What is a filter transformation and why it is an active one?
What is a predefined event?
What is the fact table?
Differentiate between a repository server and a powerhouse?
In which transformation you cannot drag ports into it?
explain abt ur project architecture?
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
How to differentiate between the active and passive transformations?
What the difference is between a database, a data warehouse and a data mart?
As union transformation gives UNION ALL output, how you will get the UNION output?
How to handle decimal places while importing a flatfile into informatica?
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?
What is meant by lookup transformation? Explain the types of lookup transformation?
How to update source definition?