how can u tune u r informatica mapppings

Question Posted / sri

2 Answers
9467 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

my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer

5 Answers IBM, TCS,

How to create or import flat file definition in to the warehouse designer?

0 Answers Informatica,

In my sourse i have like ename,gender vasu,male geetha,female ram,male suma.female kesav,male in my output i need male,female vasu,geetha ram,suma kesav

5 Answers

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers CTS,

What is incremental aggregation?

0 Answers

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers

What are the data movement modes in informatcia?

1 Answers

How to generate or load values in to the target table based on a column value using informatica etl tool.

0 Answers Informatica,

Mention few advantages of router transformation over filter transformation.