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
- 7177 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 |
write a query for how to eliminate the duplicate rows without using distinct?
what type of problem you faced insales project or insurance project
what are the limitations of pushdown optimization technique ? Advance thanks
Can we change Dynamic to Static or Persistent cache? If so what happens?
What is IQD file?
Can you create a flatfile target
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
Mention a few design and development best practices for informatica?
How can we remove the duplicates from flat file source?
Enterprise data warehouse your projects phase by phase explain?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
Teradata 
