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

What is the difference between STOP and ABORT options in Workflow Monitor?

1262


draw informatica architecture 8.6 ?

3877


What are mapplets?

1281


What is the meaning of decode in informatica?

1123


What are the types of caches in lookup?

1052


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2727


What's the layout of parameter file (what does a parameter file contain?)?

2389


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1630


How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1981


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2462


Explain target update override in informatica

1130


How many input parameters can exist in an unconnected lookup?

1551


What is a grid in Informatica?

1076


What is a shortcut and copy in Informatica and how two are different with each other?

1201


What is rank index in rank transformation?

1082