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
- 7069 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
In warehouses how many schemas are there?
How are the sources and targets definitions imported in informatica designer?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
tell me about your project functionality
What is the difference between source qualifier transformations source filter to filter transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is expression transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What does refresh system mean, and what are its distinctive choice?
Explain direct and indirect flat file loading (source file type) - informatica
Implementation methodology
What are the restrictions of union transformation?
How to load data in informatica ?
