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
What is the session task and command task?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are active and passive transformations?
draw informatica architecture 8.6 ?
what is the complex transformation you used in informatica
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What is intricate mapping?
How do you change a non-reusable transformation to reusable transformation?
What is the sequence generator transformation in informatica?
What is a filter transformation?
How to call shell scripts from informatica?
Explain the types of transformations?
How can we delete duplicate rows from flat files?
Which transformation should we use to normalise the COBOL and relational sources?
How can you define user defied event?