Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17664 Views
- CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / ashwin
We can use update override in the target table in mapping.
Push Down Optimization is an optimizing technique in
informatica 8. Integration service pushes the transformation
logic either to the source database or to the target
database rather than executing the logic by itself.
I think dynamic lookup gives a better performance since it
allows us to tune the cache sizes(index and data).
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
Define mapping and session?
What is rank index in rank transformation?
Explain lookup transformation in informatica
Performance tuning in UNIX for informatica mappings?
what is the size of your data warehousing?
What is difference between a gateway node and worker node?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Can informatica load heterogeneous targets from heterogeneous sources?
Explain informatica architecture - version 8 / 9
Enlist some properties of sessions.
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How do you load unique records into one target table and duplicate records into a different target table?
How do you load alternate records into different tables through mapping flow?
What are the differences between a connected lookup 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.
