how can u tune u r informatica mapppings

Question Posted / sri

2 Answers
8537 Views
CTS, I also Faced
E-Mail Answers

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

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers Wipro,

Suppose we do not group by on any ports of the aggregator what will be the output?

0 Answers

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers IBM,

How to delete duplicate record in Informatica?

7 Answers

What are active transformations.

0 Answers

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers Accenture, Gcs, TCS,

What are the main features of Oracle 8i with context to datawarehouse?