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

How does the aggregator transformation handle null values?

0 Answers  

How to update a particular record in target with out running whole workflow?

0 Answers  

How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers   IBM,

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  




suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

How to use Normalizer transformation?

2 Answers  

my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

can we generate reports in informatica ? How?

3 Answers  

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

For more Informatica Interview Questions Click Here
Categories