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
- 4548 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 |
What is the surrogate key?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to convert flat file into xml file? How to tune joiner?
r u done any partitions in ur project?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
Can yoU use the maping parameters or variables created in one maping into another maping?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
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?
Why update strategy and union transformations are active? Explain with examples.
what is dimension table?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Teradata 
