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

Enterprise data warehouse your projects phase by phase explain?

1477


What are the popular informatica products?

656


What are the databases that informatica can connect to windows?

593


Difference between Data and Index Caches?

664


What is joiner transformation in informatica?

632






How can you increase the performance in joiner transformation?

716


Can u generate reports in Informatica?

661


expain about the tune parameters?

1894


Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6406


What is meant by lookup transformation? Explain the types of lookup transformation?

575


tell me the rules and responsblites in our project(my project is development)

1512


What are data-driven sessions?

719


What is data transformation manager process?

628


On which transformations you created partitions in your project?

765


Do you find any difficulty while working with flat files as source and target?

682