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
- 5228 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
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is the function of union transformation?
What differs when we choose the sorted input for aggregator transformation?
In development project what is the process to follow for an etl developer from day1
What if the source is a flat-file?
How do you promote a non-reusable transformation to reusable transformation?
Why sorter is an active transformation?
What do you mean by worklet?
How can you differentiate between powercenter and power map?
Different circumstance which drives informatica server to expel records?
What is the procedure for creating independent data marts from informatica 7.1?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Repository user profiles
Can we create a Integration service without a Repository service and vice versa?
