what is data driven in update strategy transformation?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / srinu
data driven is a set of rules.based upon this rules the
integration service perfoms all operations in update
strategy transformation.
DD_INSERT
DD_UPDATE
DD_REJECT
DD_DELETE
| Is This Answer Correct ? | 6 Yes | 4 No |
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain target update override in informatica
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
Can we combine a flatfile and a database table using an UNION transformation?
How to generate a single mapping for both the historical and incremental load.
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
In how many ways we can create ports?
What are the different types of schemas?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
what is the process of target load planing?
Why update strategy and union transformations are active? Explain with examples.