how can u tune u r informatica mapppings

Question Posted / sri

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

what is the drillup & drill down?and use of the drill up and drill down?

1 Answers IBM,

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers BirlaSoft,

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers Wipro,

what is INFORMATICA TESTING process

0 Answers

Repository user profiles

0 Answers

What is Factless fact table ???

12 Answers Satyam, Tech Mahindra,

Which version configuration tool used in ur project?

0 Answers CTS, TCS,

plz plz plz send client names and project names in informatica?

1 Answers

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers TCS,

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers

For more Informatica Interview Questions Click Here