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 many types of sessions are there in informatica.please explain them?
How to do the error handling of if ur source is flatfiles?
can we override a native sql query within informatica? Where do we do it? How do we do it?
what is the Default Source Option For Update Strategy Transformation?
How will the document be delivered to me?
What is the command used to run a batch?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Can anyone tell me the new features in Informatica 9 Version?
How can we update a record in the target table without using update strategy?
What are the components of Informatica? And what is the purpose of each?
What are the types of lookup transformation?
What is native users?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain why we use partitioning the session in informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar