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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

Question Posted / rakeshm4119

Answers were Sorted based on User's Feedback



how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?..

Answer / abhinaw prakash

If we are using a table as a source and we want to find out
the bottle neck is the SQ then run the mapping and note down
the timing which it has taken in reading the data from the
source and then replace the source with a Flat file.Note
down the timing and compare to find out the bottleneck in SQ.

Is This Answer Correct ?    1 Yes 0 No

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?..

Answer / 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

More Informatica Interview Questions

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z

3 Answers   CTS,

Is it possible to create multiple domains on a single Informatica server?

0 Answers  

What did you do in source pre load stored procedure

1 Answers  

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

What are the informatica performance improvement tips

0 Answers   Informatica,

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

explain different types of modeling.

2 Answers  

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

What do you understand by a term domain?

0 Answers  

How informatica process data means how informatica works?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories