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
- 7015 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
Do you find any difficulty while working with flat files as source and target?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the reusable transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Difference between Data and Index Caches?
What are the types of data warehouses?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
When do you use sql override in a lookup transformation?
Why union transformation is an active transformation?
Explain dynamic target flat file name generation in informatica
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is rank transform?
What is an expression transformation in informatica?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
