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 to load last n records of file into target table - informatica

1072


What are the popular informatica products?

1008


How do you manage the Parameter files while migrating your data from one environment to another environment?

1015


What are the types of data warehouses?

1520


What is the function of union transformation?

1127


Can we create two repositories on same database instance in oracle?

1087


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1118


When do you use sql override in a lookup transformation?

1090


Why filter transformation is an active one?

977


Briefly explain the aggregator transformation?

995


What are the different types of repositories created using informatica?

1126


What are the mapping parameters and mapping variables?

1200


What is substr in informatica?

1203


Does an informatica transformation support only aggregate expressions?

1037


Explain the types of transformations?

1061