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


Which kind of index is preferred in DWH?

Answers were Sorted based on User's Feedback



Which kind of index is preferred in DWH?..

Answer / ande

we have bitmap index, b-tree index, function based index,
reverse key index and composit index. we will use bitmap
index in DWH
Regards,
ande

Is This Answer Correct ?    7 Yes 0 No

Which kind of index is preferred in DWH?..

Answer / ghouse

to load the data into the fact table b tree index is created
and bit is used where the cordinality of the coloumn is very
low i.e(in dwh-denormalised one)(OLAP)

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

How does the session recovery work.

1 Answers  


1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  


Different types of Power center errors?

1 Answers   Cinterco, IBM,


What is the procedure to load the fact table.Give in detail?

1 Answers  


can anyone suggest best free Talend data integration training online

0 Answers  


Which development components of informatica have the highest usage?

0 Answers  


AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,


What is a test load?

1 Answers  


what is size of u r database?

0 Answers  


What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,


What are roles and groups and benefits of using them?

0 Answers  


Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  


Categories