how can u tune u r informatica mapppings
Answers were Sorted based on User's Feedback
Answer / bsgsr
mappings can be tuned at diff transformations level.
ex; look up can be optimised by enabling the cache.
aggregator can be optimised by using sorted inout.
filter can be optimised by using it as close as possible
to the sql. so on
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vdrona
Mapping can be tuned by identifying the following bottlenecks in order shown below.
1. Target Bottlenecks
2. Source Bottlenecks
3. Transformation/Mapping Bottlenecks
4. Session Bottlenecks
5. System Bottlenecks
Is This Answer Correct ? | 6 Yes | 1 No |
While importing the relational source defintion from database,what are the meta data of source U import?
As union transformation gives UNION ALL output, how you will get the UNION output?
what is meant by data driven.. in which scenario we use that..?
how to calculate the optimum cache size in aggregator transformation?
what is the use of Data Mart?
How to call shell scripts from informatica?
how do u move the code from development to production?
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
Explain what transformation and how many are there in informatica?
What does reusable transformation mean?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is InformaticaPowerCenter?