Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


how can u tune u r informatica mapppings

Answers were Sorted based on User's Feedback



how can u tune u r informatica mapppings..

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

how can u tune u r informatica mapppings..

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

Post New Answer

More Informatica Interview Questions

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  


Explain factlessfact table with scenario

1 Answers   HCL,


explan ur project architecture?

0 Answers   TCS,


If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,


What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,






Define joiner transformation?

0 Answers  


How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


What do think which one is the better joiner or look up?

0 Answers  


Differentiate between a database and data warehouse?

0 Answers  


i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,


What is parallel processing in informatica?

0 Answers  


how to obtain performance data for individual transformations.

2 Answers  






Categories