Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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..?

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


Please Help Members By Posting Answers For Below Questions

How many types of sessions are there in informatica.please explain them?

1210


How to do the error handling of if ur source is flatfiles?

2017


can we override a native sql query within informatica? Where do we do it? How do we do it?

1113


what is the Default Source Option For Update Strategy Transformation?

1287


How will the document be delivered to me?

1129


What is the command used to run a batch?

1111


What are the steps involved in the migration from older version to newer version of Informatica Server?

2153


Can anyone tell me the new features in Informatica 9 Version?

2207


How can we update a record in the target table without using update strategy?

1202


What are the components of Informatica? And what is the purpose of each?

1108


What are the types of lookup transformation?

1119


What is native users?

1223


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1080


Explain why we use partitioning the session in informatica?

1163


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

2796