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?

Answer Posted / warrenrame

Bitmap index is the best one. why because B-tree is suited
for unique values(eg: empid) and Bitmap is best for repeated
values(eg: gender m/f)

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the advantages data mining over traditional approaches?

956


What is the difference between snowflake and star schema?

1029


What is data warehosuing hierarchy?

1133


Explain the definition of normalized and denormalized view and what are the differences between them?

912


What is the data type of the surrogate key?

984


What is the difference between metadata and data dictionary?

1114


Explain what are the various file formats involved in reportnet?

910


Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?

1104


Tell me what is full load & incremental or refresh load?

931


What is the difference between view filter and report filter?

911


Where do we use semi and non additive facts?

972


What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1041


What is a core dimension?

1044


What are the various file formats involved in reportnet?

949


What is edw?

1173