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

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  


How Union Transformation is an Active Trans?

6 Answers  


i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,


what is informatica metadata?

0 Answers  


Describe two levels in which update strategy transformation sets?

1 Answers  


expain about the tune parameters?

0 Answers   TCS,


why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,


have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,


What are the different clients of powercenter?

0 Answers  


What are the uses of a Parameter file?

3 Answers   CSC,


what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,


what is the complex transformation you used in informatica

0 Answers   TCS,


Categories