Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 34588 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / ram reddy
Update Override it is an option available in TARGET
instance.By defalut Target table is updated based on
Primary key values.To update the Target table on non
primary key values u can generate the default Querey and
override the Querey according to the requiremnet.Suppose
for example u want to update the record in target table
When a column value='AAA' then u can include this condition
in where clause of default Querey.
Coming to SQL override it is an option available in Source
Qualifier and Lookup transafornmation where u can inlude
joins ,filters,Group by and order by.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is the Process to creating lookup transformation in informatica
What are active and passive transformations?
What is intricate mapping?
Explain the types of lookup transformation?
what are the Methods For Creating Reusable Transformations?
Differentiate between a database and data warehouse?
What are the different ways to implement parallel processing in informatica?
What is sorter transformation?
Differentiate between sessions and batches?
Explain what are the different versions of informatica?
What is an active transformation?
Did u used latest transformations of 8.6.0? for what?
What is deployment group?
What is workflow? What are the components of the workflow manager?
