Answer Posted / 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 |
Post New Answer View All Answers
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
can u any challenge your project?
Explain how many types of dimensions are available in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
What is dynamic cache?
Explain the mapping variable usage example in informatica
How does a rank transform differ from aggregator transform functions max and min?
Explain the aggregator transformation?
wf dont have integration severances how you can run?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Does an informatica transformation support only aggregate expressions?
What is an aggregator transformation?
What is workflow manager?
Explain the types of transformations?