how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Answer Posted / 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 |
Post New Answer View All Answers
What does “tail –f” command do and what is its use as an Informatica admin.
What is session task and command task?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How do you load unique records into one target table and duplicate records into a different target table?
How does a sorter cache works?
What is a connected transformation?
Enlist the differences between database and data warehouse.
Slowly changing dimensions, types and where will you use them
What are the differences between joiner transformation and source qualifier transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain the difference between a data warehouse and a data mart?
What is the Rank index port in Rank transformation?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain Dataware house architecture .how data flow from intial to end?
How would you copy the content of one repository to another repository?