how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
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 load last n records of file into target table - informatica
What are the popular informatica products?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What are the types of data warehouses?
What is the function of union transformation?
Can we create two repositories on same database instance in oracle?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
When do you use sql override in a lookup transformation?
Why filter transformation is an active one?
Briefly explain the aggregator transformation?
What are the different types of repositories created using informatica?
What are the mapping parameters and mapping variables?
What is substr in informatica?
Does an informatica transformation support only aggregate expressions?
Explain the types of transformations?