Which kind of index is preferred in DWH?
Answer / 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 |
What are partition points?
How are models actually derived?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Explain a relation schema and a relation?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What is Snow Flake Schema design in database?
Best institute for MS BI training in Hyderabad, India?
If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?
3 Answers Extech, Principal Finance,
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
How to create diff. Types of templates?
What is the difference between filter and lookup transformation?
Explain what is real time data-warehousing?