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
- 6914 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
What is meant by target load plan?
What are the transformations that are not supported in mapplet?
Performance tuning( what you did in performance tuning)
How do you manage the Parameter files while migrating your data from one environment to another environment?
Which development components of informatica have the highest usage?
Do you find any difficulty while working with flat files as source and target?
Scheduling properties,whats the default (sequential)
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Which is the t/r that builts only single cache memory?
without table how to come first record only in oracle?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How can we improve session performance in aggregator transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What you know about transaction control transformation?
