how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we

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

Question Posted / rakeshm4119

2 Answers
7014 Views
Zensar, I also Faced
E-Mail Answers

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

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers iGate,

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers IBM,

What is Collect performance data in informatica and what is the use of it.

1 Answers Informatica,

what is mean by flag 4 in update strategy t/r

6 Answers

why we use materialized view over view?

1 Answers Zensar,

what is difference between COM & DCOM?

1 Answers Satyam,

how many types of dimensions are available in informatica?

0 Answers

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?