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 aggregate cache in aggregator transforamtion?
What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?
how do u fnd the duplicate rows and how to delete the duplicate rows?
can we load the data with out a primary key of a table? what is target plan?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
What are the Differences between connected and unconnected lookup?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
what is parameter file?
what is shared Cache. when we will use shared Cache?
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
diffrence between command task and control task