hi, as al you know, we can set the option in session level
as all rows treat as like insert,update etc., And also we
have update strategy for flaging records as insert,update
etc.. then when we will go for above options and what is
the difference.. explain..



hi, as al you know, we can set the option in session level as all rows treat as like insert,update..

Answer / john

Bydefaultly the option in the session properties "Treat
source rows as" is set as Insert.But When we use
Updatestrategy in our mapping, the option in the session
level automatically becomes "Data driven".that means all
the source rows are treated as per the condition you
specified in the updatestrategy transformation.lets say you
have specified as "DD_UPDATE" then integartion service will
treat all the source rows as "UPDATE".
Actually when we use Updatestrategy transformation in
mapping level there is no need of change the settings in
the session level..as i told you earlier the option "Treat
source rows as" is bydefaultly Insert.
But with out using Updatestrategy how wll the Update the
records? or How will you Reject the records? or How will
you Delete the records?
The answer for this Question is...By using the option
called "Treat source rows as"..
so Use this option when you want to update/Reject/Delete
the records with out using the Updatestrategy in mapping
level..

Is This Answer Correct ?    9 Yes 1 No

Post New Answer

More Informatica Interview Questions

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION

4 Answers  


how can u approach u r client

2 Answers   CTS,


What if the source is a flat-file?

0 Answers  


In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,


what is mapping performence?

2 Answers   Cap Gemini,






What are the tasks that Loadmanger process will do?

1 Answers  


i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  


what are the transformations that restricts the partitioning of sessions?

1 Answers  


Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,


Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,


Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers  


How to generate sequence numbers?

0 Answers  


Categories