Interested to Buy Any Domain ? << Click Here >> for more details...
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
- 2 Answers
- 7178 Views
- Zensar, I also Faced
- E-Mail Answers
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
How to start a workflow using pmcmd command?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What are Dimensional table?
What are the settings that you use to configure the joiner transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the different ways to implement parallel processing in informatica?
Briefly explain the aggregator transformation?
What is Session and Batches?
How to extract the informatica rejected data?
How many ways are there to create ports?
What do you mean by worklet?
What are the main issues while working with flat files as source and as targets ?
What is a pre-defined event and user-defined event?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
