Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5163 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Can i create a lookup table without cache.
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
What is the difference between sequential batch and concurrent batch and which is recommended and why?
Plz can any one say me how to get the informatica certification materials and dumps
How can u work with remote database in informatica?did you work directly by using remote connections?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
In Which scenario did u used Incremental loading?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
explain one complex mapping with logic? sales project?
0 Answers Accenture, JPMorgan Chase,
Different circumstance which drives informatica server to expel records?
What are the types of lookup caches?
10 Answers Accenture, IBM, Informatica,
Teradata 
