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

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  


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

0 Answers   Informatica,


What are the restrictions of union transformation?

0 Answers  


i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,


can u give example for factless fact table

2 Answers   TCS,


What is the function of look up transformation?

0 Answers  


1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers   Cap Gemini,


Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,


what is the gap analysis?

1 Answers  


Performance tuning( what you did in performance tuning)

0 Answers   Infosys,


Can we use unconnected lookup as dynamic lookup?

5 Answers   ITC Infotech, TCS, Wipro,


How can you recover the session in sequential batches?

1 Answers  


Categories