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

How we are using this function?

1188


What is the difference between snowflake and star schema?

1099


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

1042


How do you setup Lo-cockpit?

3241


Explain a mapping, session, worklet, workflow, mapplet?

1152


How to pivot data using informatica when you have variable amount of pivot rows?

953


Explain what is the difference between stop and abort?

1093


Difference between cold fusion 5 and cold fusion mx 6?

1047


What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

956


What are the advantages of query studio compared to report studio?

943


What is ods (operation data source)?

1060


How are models actually derived?

2062


What are the different problems that ?Data mining? can solve?

2889


How would you write a left join statement to return a result set of movie.title�s and director.name�s?

1097


Explain reference cursor?

2226