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
- 7055 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 / 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 |
tell me the push down optimization
What is informatica? Why do we need it?
What are the tuning techniques you applied during your last project
Is there any model difference between ODS and DWH
Why use the lookup transformation ?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
write sql query to remove null value following table id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output id name 101 dinesh 102 suresh 103 prakesh
What is the difference between SOURCE and TARGET BASED COMMITS?
What is the difference between a router and a filter transformation?
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
Why we need XMLs?
Teradata 
