what is data driven?
Answers were Sorted based on User's Feedback
Answer / guest
data driven is the instruction fed to informatica server
wheather to insert/update/delete row whenever using update
strategy transformation
| Is This Answer Correct ? | 59 Yes | 7 No |
Answer / ziauddin
When u configure a session using update strategy the
session property data driven instructs informatica server
to use the instructions coded in mapping to flag the rows
for insert, update, delete, this is the default option
selected when using a update strategy transformation in a
mapping.
| Is This Answer Correct ? | 32 Yes | 5 No |
Answer / kamesh
When ever a mapping contains Update Strategy Transformation
the way data needs to be treated is declared in the session
property as Data Driven. This is done by mentioning
DD_UPDATE or DD_INSERT or DD_DELETE in the update strategy
transformation.
A mapping may contain two Update strategy transformations,
1 for inserting and another for updating in two different
pipelines in single mapping.
Therefore, in order session to get executed successfully,
mention Data Driven property in the session properties for
that particular mapping.
| Is This Answer Correct ? | 23 Yes | 3 No |
Answer / yaseen
Data driven is a process, in which data is
insert/deleted/updated based on the data. here it is not
predifed tht data is to insert or delete or update .. it
will come to knw only when data is proceesed
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / maheshg
The informatica server follows instructions coded into
update Strategy transformations with in the session maping
determine how to flag records for insert,update,,delete or
reject If u do not choose data driven option setting,the
informatica server ignores all update strategy
transformations in the mapping
| Is This Answer Correct ? | 2 Yes | 0 No |
Write the unconnected lookup syntax?
Explain the different lookup methods used in informatica?
What is batch and describe about types of batches?
How to retrieve last two days updated records?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
how the informatica server sorts the strings values in rank transformations?
what are the difference between Informatica 7.1 and 8.1?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
Without using Lookup & Sequence Generator, How to generate Sequence?