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 one know that a table has indexes and is
partitioned? How data will be pulled from Partitions in
Oracle for Informatica?



How can one know that a table has indexes and is partitioned? How data will be pulled from Partitio..

Answer / hari

to look at the explain plan of the sql query which is issue
to database from infomatica.
have a look at the user_indexes with
table_name=<<TABLENMAE>>
have a look at user_tab_partition where
table_name=<<TABLE_NAME>>
TABLENAME, which are used in the informatica sql query...

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

how to delete duplicate records by using filter transfermation?

3 Answers  


which quality process u can approach in ur project

1 Answers   CTS,


scenario

1 Answers  


can any one explain me about junk dimension

4 Answers  


what type of problem you faced insales project or insurance project

1 Answers   Sony,


what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,


any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com

1 Answers  


source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

1 Answers   IBM,


If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  


what is datamart

4 Answers   IBM, Informatica,


What is a dimensional model?

0 Answers  


What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  


Categories