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

What are the differences between oltp and olap?

0 Answers  

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

0 Answers   Bank Of America,

What are the data movement modes in informatcia?

3 Answers  

what is the difference between lookupoveride and joiner?

3 Answers  

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,




For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

What are the types of schemas we have in data warehouse.

0 Answers  

In informatics server which files are created during the session rums?

0 Answers  

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

What are events in workflow manager?

1 Answers   Accenture, IBM,

For more Informatica Interview Questions Click Here
Categories