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
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
can you please explain me pre session and post session options?
What are the transformations that are not supported in mapplet?
What are mapplets?
What are the mapping parameters and mapping variables?
Can you generate sequence numbers without using the sequence generator transformation?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to differentiate between the active and passive transformations?
tell me the rules and responsblites in our project(my project is development)
How might one distinguish in the case of mapping is right or not without associating session?
Design time, run time. If you don't create parameter what will happen
Differences between connected and unconnected lookup?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is joiner transformation in informatica?
What is session task and command task?