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 |
2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?
How to join three sources using joiner? Explain though mapping flow.
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
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
how do u tune queries?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
From where we can start or use pmcmd?
How to update records in Target, without using Update Strategy?
HOW TO DELETE A RECORD FROM FLAT FILE
what are objects in data warehouse?
What is meant by query override?
Explain pmcmd command usage in informatica