WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?

Answers were Sorted based on User's Feedback



WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?..

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

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?..

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

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?..

Answer / raj

u can get this "update override" by double clicking or right
clicking the target .

Is This Answer Correct ?    9 Yes 2 No

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?..

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

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?..

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

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?..

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

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?..

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

Post New Answer

More Informatica Interview Questions

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  


following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,


Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,


Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,


Why union transformation is an active transformation?

0 Answers   Informatica,






in which situations do u go for starflake schema ?

6 Answers   TCS,


How many repositories can we create in Informatica?

3 Answers  


why we are using level option in normalizer transformation

0 Answers   TCS, Wells Fargo,


my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.

5 Answers   TCS,


Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  


How many number of sessions can one group in batches?

0 Answers  


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


Categories