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 an unconnected transformation?
Can we create a Integration service without a Repository service and vice versa?
What are the advantages of informatica?
What is a difference between complete, stop and abort?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Can we override a native sql query within informatica?
Which transformation should we use to normalise the COBOL and relational sources?
How many number of sessions can one group in batches?
What are the different lookup cache(s)?
Explain pmcmd command usage in informatica
What is informatica powercenter repository?
Plz can any one say me how to get the informatica certification materials and dumps
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Explain your project of banking domian.
What is the benefit of session partitioning?