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
- 5225 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 |
waht type of interface is used for testing the data in informatica
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the Difference between SetVariable and setmaxvariable in informatica?
Which kind of index is preferred in DWH?
tell me 7.x and 8.x diferrencess(but not transformations)
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
What are the different options used to configure the sequential batches?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
What are the differences between joiner transformation and source qualifier transformation?
what is the difference between mapplet & stored procedure?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
Teradata 
