how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
- 3 Answers
- 7264 Views
- Zensar, I also Faced
- E-Mail Answers
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 / Kumar Saurabh
In Informatica, you can use the 'SQL Profiler' to monitor the performance of SQL queries. To find bottlenecks, analyze query execution statistics such as CPU usage, disk I/O, and network traffic. To optimize the SQL queries, consider using indexes, reducing the query complexity, and tuning database parameters like buffer size and connection pool size.
| Is This Answer Correct ? | 0 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 |
How to display First letter of Names in Caps?
What is sql query override? When did u use sql query override?
Which transformation should we use to normalise the COBOL and relational sources?
what is the size of u r source(like file or table)?
In development project what is the process to follow for an etl developer from day1
How you prepared reports for OLAP?
what are cost based and rule based approaches and what is the difference?
can you avoid static cache in the lookup transformation? I mean can you
How can u work with remote database in informatica?did you work directly by using remote connections?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
what is the gap analysis?
What is the difference between a router and a filter transformation?
Teradata 
