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

can anybody mail me the FAQS for hyperion essbase amd planning

5383


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

791


Explain what is the difference between olap and datawarehosue?

822


What are the methodologies of data warehousing?

747


Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

841


Explain multivalued dependency?

749


How to create context?

765


Compare and contrast aggregates & indexes

3534


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

695


What are session timeout and application timeout? Where we have to do this process?

783


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

826


Difference between cold fusion 5 and cold fusion mx 6?

774


Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?

760


What are snapshots? What are materialized views & where do we use them?

735


What is "method/1"?

741