WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
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
What are the tuning techniques you applied during your last project
update strategy transformation in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is flashback table ? Advance thanks
How to elaborate powercenter integration service?
How will the document be delivered to me?
How do you convert single row from source into three rows into target?
What is the command used to run a batch?
Write the program through which the records can be updated?
How to differentiate between the active and passive transformations?
What is the need for an etl tool?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the different ways to implement parallel processing in informatica?
Explain the mapping variable usage example in informatica
pmscmd startworkflow -sv