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 |
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
HOW DO YOU PARFORM INCREMENTAL LAOD ?
how to identify new and old values in source qualifier or any other transformations using informatica
What is a data modeling?
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
what are the difference between Informatica 7.1 and 8.1?
What are the Differences between static cache and dynamic cache?
How are the sources and targets definitions imported in informatica designer?
Explain your project of banking domian.
enterprise datawarehouse your project phase by phase explain?
write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690