what is meant by data driven.. in which scenario we use
that..?
Answers were Sorted based on User's Feedback
Answer / swathi
data driven is available at session level.it says that when
we r using update strategy t/r ,how the integration service
fetches the data and how to update/insert row in the
database log.
Is This Answer Correct ? | 5 Yes | 0 No |
Data driven is nothing but but instruct the source rows that
should take action on target i.e(update,delete,reject,insert).
If we use the update strategy transformation in a mapping then
will select the datadriven option in session.
reply me if am wrong
teja_dwh@yahoo.com
Is This Answer Correct ? | 1 Yes | 1 No |
what is upstream and downstream transformation?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?
when will we go for unconnected lookup transformation in Informatica?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
What is a parameter When and where do you them when does the value will be created
What are the associated ports in look up T/R.
How to generate a single mapping for both the historical and incremental load.
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
have u done any performance tuning? how u ll do?
What is informatica metadata and where is it stored?
What is confirmed dimension?