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 do you mean by worklet?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Tell me about MD5 functions in informatica
Which files are created during the session rums by informatics server?
In development project what is the process to follow for an etl developer from day1
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
what is the complex transformation you used in informatica
Explain in detail about scd type 1 through mapping.
Mention some types of transformation?
What is a sequence generator transformation?
What will be the approach?
How can we use batches?
Explain constraint based loading in informatica
What is workflow? What are the components of workflow manager?
Informatica settings are available in which file?