WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 32160 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
What is the difference between STOP and ABORT options in Workflow Monitor?
can you please explain me pre session and post session options?
What is meant by incremental aggregation?
Do you find any difficulty while working with flat files as source and target?
Differences between version 7.x and 8.x.
What happens when a session fails and you click on recover?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are the restrictions of union transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the differences between source qualifier and joiner transformation?
How to load the data from people soft hrm to people soft erm using informatica?
Explain the different dimensions.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
Did u used latest transformations of 8.6.0? for what?
Please let me know how to make Data masking in informatica..
