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 |
when will we go for unconnected lookup transformation in Informatica?
HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com
What is confirmed dimension?
What is batch and describe about types of batches?
Which kind of index is preferred in DWH?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
what is the look up transformation?
What are the tasks that can be performed using sq?
what is incremantal aggregation?