how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.

Answer Posted / infa dev

Just using the Update override won't get your work done.
You will have to select the session property Treat source
rows as 'Update'

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

waht type of interface is used for testing the data in informatica

1927


where to store informatica rejected data?

766


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1651


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

1881


How to update source definition?

724






While importing the relational source definition from the database, what are the metadata of source that will be imported?

912


Is there any target staging area in informatica not staging area

2231


What is expression transformation?

722


wat are deployement groups in informatica, how it will be used for developers

1355


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

5780


Explain load alternative records / rows into multiple targets - informatica

808


Describe data concatenation?

665


is it possible to index the data in cache of lkp transformation ?

1626


Differentiate between Load Manager and DTM?

1761


What is Cognos script editor?

3868