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 rows into fact table in data warehouse
What is incremental aggregation?
whats the logic to load the lower level of granularity of data to fact table.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Explain the difference between a data warehouse and a data mart?
What is the difference between Active and Passive transformation?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the restrictions of union transformation?
Define mapping and session?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is meant by LDAP users?
What is xml source qualifier transformation in informatica?
Explain the etl program with few examples.
difference between repository database and repository service?