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
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Is there any target staging area in informatica not staging area
How do you promote a non-reusable transformation to reusable transformation?
What differs when we choose the sorted input for aggregator transformation?
Write the unconnected lookup syntax and how to return more than one column.
whats the logic to load the lower level of granularity of data to fact table.
What is dimensional table? Explain the different dimensions.
Define filter transformation?
what is the size of your data warehousing?
What is the difference between a connected look up and unconnected lookup?
How to partition the Session?
What is union transformation in informatica?
What is decode in static cache?
What all join we can perform in LOOKUP transformation?
How to elaborate tracing level?