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.

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.

Answer / raj

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

Answer / vishnu_kr

hi,

sorry for a small mistake in the last answer

u use 'update else insert' property in the session mappings
tab.

Answer / lokendra

You can override the WHERE clause to include non-key
columns by using target 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.....

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

What happens when a session fails and you click on recover?

0 Answers  

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

why union transformation is active transformation?

6 Answers   IndiGo, TCS,

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

Mapplets can you use an active transformation in a mapplet,

1 Answers  

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,