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
What is rank transformation?
What is data movement mode in Informatica and difference between them?
is it possible to index the data in cache of lkp transformation ?
difference between repository database and repository service?
What is the difference between Active and Passive transformation?
Separate from a database, an information bazaar, and an information stockroom?
What is union transformation in informatica?
What are the modules in Power Center
What is parallel processing in informatica?
How might you approve all mappings in the archive all the while?
What is the surrogate key?
Please let me know how to make encryption and decryption with example?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Different sorts of metadata that stores in the storage facility?
Explain about cumulative Sum or moving sum?