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


Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance
issue. how to fix the performnce issue of the query.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?

10 Answers   Wipro,


my source table having sureshraj42@gmail.com and rajeshraj42@gmail.com and i have only sureshraj and rajeshraj for my target table which transformation i have to use in informatica

3 Answers   HP,


Types of error logs in Informatica?

2 Answers  


How you load distinct records into one target and duplicate records into another target?

3 Answers   Mphasis,


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,


What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers  


Why use the lookup transformation ?

2 Answers   Informatica,


in reporting we add some new objects,how we get the count of the newly added objects to the report

0 Answers   HP,


What are the prerequisite tasks to achieve the session partition?

0 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


What is a design?

1 Answers  


Mapplets can you use an active transformation in a mapplet,

1 Answers  


Categories