how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Answers were Sorted based on User's Feedback
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 |
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 |
What are connected or unconnected transformations?
explain different levels in pushdown optimization with example?
what happens if you try to create a shortcut to a non- shared folder?
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
What is workflow monitor?
How to convert multiple rows to single row (multiple columns) in informatica
What is the Router transformation?
Explain the difference between mapping parameter and mapping variable?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
What is Code Page Compatibility?
I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do