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 / sambasivarao.m

By using Update override option in Target table we can
update the table

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

r u done any partitions in ur project?

1475


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7894


Is stop and abort are same in informatica?

657


what is the complex transformation you used in informatica

2288


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

907






In informatica workflow manager, how many repositories can be created?

938


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

752


What is dimensional table? Explain the different dimensions.

769


What is meant by lookup transformation?

699


Target increases every day even though no new record was inserted

1223


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1604


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1316


How many types of sessions are there in informatica.please explain them?

777


How will the document be delivered to me?

706


Explain the tuning lookup transformation - informatica

694