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 main difference between schema in rdbms and schemas in datawarehouse?

1081


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

941


Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

1015


What is the difference between olap and datawarehosue?

947


Explain what are slowly changing dimensions?

1021


What is latest version of power center / power mart?

1045


Explain about core dimension, balanced dimension, and dirty dimension?

1002


How do you create surrogate key using ab initio?

989


ware house management system is used?

1000


What is the use of dimensional modeling in data warehousing?

980


What is the difference between power center and power mart?

1018


Explain what is the main difference between inmon and kimball philosophies of data warehousing?

978


What is perform recovery?

1080


What are the different types of join operations?

992


What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1068