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
hi real timers . iam waiting for ur reply regarding ETL TESTING
Differences between version 7.x and 8.x.
How we can create indexes after completing the loan process?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is a predefined event?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is a difference between complete, stop and abort?
Write the advantages of partitioning a session?
How many number of sessions can one group in batches?
What is meant by lookup transformation?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
How can we use mapping variables in informatica? Where do we use them?
Have you worked with/created Parameter file
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Can we get 1st record through Informatica(without sequence number).