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..
- 1 Answers
- 4527 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are the types of schemas we have in data warehouse.
What are the differences between a connected lookup and unconnected lookup?
Different circumstance which drives informatica server to expel records?
In informatics server which files are created during the session rums?
define galaxy repository in informatica
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Explain about Informatica server process that how it works relates to mapping variables?
How can informatica be used for an organization?
How to create the source and target database connections in server manager?
What is a dimensional model?
What is the function of aggregator transformation?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How you can differentiate between connected lookup and unconnected lookup?
What is an expression transformation in informatica?
Mention a few design and development best practices for informatica?
