1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

Question Posted / rakeshm4119

Answers were Sorted based on User's Feedback



how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?..

Answer / abhinaw prakash

If we are using a table as a source and we want to find out
the bottle neck is the SQ then run the mapping and note down
the timing which it has taken in reading the data from the
source and then replace the source with a Flat file.Note
down the timing and compare to find out the bottleneck in SQ.

Is This Answer Correct ?    1 Yes 0 No

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?..

Answer / vijaya

BY seeing the session log file we identify the source qualifier bottle necks in the mapping

if we find the bottle neck on source qualifier transformation change the properties in SQ

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More Informatica Interview Questions

performance tuning of Informatica

1 Answers  

What are the data movement modes in informatcia?

3 Answers  

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,




Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

Explain pmcmd command usage in informatica

0 Answers   Informatica,

How many input parameters can exist in an unconnected lookup?

0 Answers  

How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

How many repositories can we create in Informatica??

9 Answers   IBM, Patni,

For more Informatica Interview Questions Click Here
Categories