WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 32113 Views
- Target, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vishnu_kr
Hi,
i guess the SQL override is used in the source qualifier trf
to implement joins, filter, sorter etc..
but update override is used in the Target table definition.
u use this option to update Targets that have no primary
key (hence u can't use update strategy) coupled
with 'Update as update' property in the session mappings tab
and 'Treat rows as' property set as 'Update' in the session
Properties tab.
| Is This Answer Correct ? | 25 Yes | 3 No |
Answer / 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 |
Answer / raj
u can get this "update override" by double clicking or right
clicking the target .
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / vishnu_kr
hi,
sorry for a small mistake in the last answer
u use 'update else insert' property in the session mappings
tab.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / lokendra
You can override the WHERE clause to include non-key
columns by using target override
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / praveen kumar pendekanti
In the case of source qualifier when we use sql override
opition we will get query with our alias name and when we
user update transformation override when we enter update
override we will get column names with alias name
In update transformation order by clause is default that is
not in sql over ride(According to my knowledge)
If i am wrong plz correct me to my mail-id.....
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / uzval_vee
hai
i guess this question comes under scd's itseems,
becoz in scd type1 we will overwrite the oldvalue with new
value.here we dont have any history
| Is This Answer Correct ? | 3 Yes | 10 No |
Explain sessions. Explain how batches are used to combine executions?
What is DTM process?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?
what are the difference between Informatica 7.1 and 8.1?
What happens when a session fails and you click on recover?
In informatics server which files are created during the session rums?
what is SDLC way of code development?
what is a time dimension? give an example?
how the server recognises , if the session fails after loading the 100 records in to the target
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.
5 Answers FCS, IBM, Satyam, TCS,
Is there any way to read the ms excel datas directly into informatica?
Teradata 
