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 / usha
without using update transformation we can update by using
update overide if the target doent have a PK...
:TU
------------------------
push down operation in informatica means it will convert
transfromation logic to SQL query..
3 types..
source push down
target push down
full push down.
------------------------
connected lkp will give good prformence..
lookup gives more tuning performance
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How do you take back up of repository?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Which version configuration tool used in ur project?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to create or import flat file definition in to the warehouse designer?
Define update strategy?
Which transformation is needed while using the Cobol sources as source definitions?
What is the difference between source qualifier transformations source filter to filter transformation?
How can we handle two sessions in informatica?
Explain what are the different types of transformation available in informatica.
What are the types of schemas we have in data warehouse.
Differentiate between sessions and batches?
What can we do to improve the performance of informatica aggregator transformation?