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
- 6904 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
Write the unconnected lookup syntax and how to return more than one column.
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the cumulative sum and moving sum?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Can we override a native sql query within informatica?
What is the session task and command task?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the difference between writing a joiner query in ANSI style and THETA style?
Differentiate between Load Manager and DTM?
Design time, run time. If you don't create parameter what will happen
How to generate sequence numbers using expression transformation?
How to delete duplicate row using informatica?
In how many ways we can create ports?
What are the various types of transformation?
