how can we update without using update transformation.
wt is push down operation in informatica.
which lookup gives more tuning performance. if so why.
- 6 Answers
- 15909 Views
- CTS, Symphony, I also Faced
- E-Mail Answers
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 differs when we choose the sorted input for aggregator transformation?
can we override a native sql query within informatica? Where do we do it?
Can informatica load heterogeneous targets from heterogeneous sources?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
can u any challenge your project?
How are indexes created after completing the load process?
What is workflow manager?
Explain how to import oracle sequence into informatica?
Explain incremental aggregation in informatica
How do you change a non-reusable transformation to reusable transformation?
What is the commit type if you have a transaction control transformation in the mapping?
explan ur project architecture?
What does command task mean?
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the main features of Oracle 8i with context to datawarehouse?
