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

Explain reference cursor?

2167


What is the difference between aggregate table and materialized view?

1100


What are steps we have to follow in designing the userfriendly universe?

978


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

1116


Can any one explain the hierarchies level data warehousing.

992


what are the others of "bad files" and "discard files" when using sql*loader?

2133


Can you pass sql queries in filter transformation?

1018


What is the difference between junk dimension and degenerated dimension?

1136


Explain what are the modules in power mart?

1051


What is the difference between snowflake and star schema?

1050


What is the limit to the number of sources and targets you can have in a mapping?

1108


Where the applications and where ware house management system is used?

1015


How can we determine what records to extract?

1081


What are diagrams?

1042


What are the advantages of raid 1, 1/0, and

980