what is meant by data driven.. in which scenario we use
that..?
Answer Posted / teja_dwh
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 |
Post New Answer View All Answers
What are the types of data warehouses?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the designer tools for creating transformations?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What's the layout of parameter file (what does a parameter file contain?)?
What is the need of an ETL tool?
What are the different clients of powercenter?
What is the sequence generator transformation in informatica?
how to load rows into fact table in data warehouse
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is joiner change?
Explain the use of aggregator cache file?
What is fact table? Explain the different kinds of facts.
What is union transformation?
Can we override a native sql query within informatica?