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 / bsgsr
without using update t/mation also we can update. in
session properties select update against treat source rows
as. this wud definitely help you.
push down is a function of 8.1 version of informatica. it
reduces the load on informatica server.
unconnceted obviously bcoz not connected with the data flow
and uses only static cache.
also it can be called as many times in a mapping as a
result of an expession.
reach me on 9866188658.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Can informatica load heterogeneous targets from heterogeneous sources?
What is the function of look up transformation?
Define sessions in informatica etl?
Which are the different editions of informatica powercenter that are available?
What are the databases that informatica can connect to windows?
What are the data movement modes in informatica?
What is aggregator transformation in informatica?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to implement security measures using repository manager?
What is a predefined event?
What is the function of aggregator transformation?
What the difference is between a database, a data warehouse and a data mart?
Difference between Data and Index Caches?
What is the use of source qualifier?
can we override a native sql query within informatica? Where do we do it?