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 |
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
hw cn v elimate dublicate values from lookup without overriding sql?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
what is mean by throghput? in informatica
how to obtain performance data for individual transformations.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
EXL informatica Questions
How to load last n records of file into target table - informatica
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
tell me the rules and responsblites in our project(my project is development)