Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to eliminate duplicate rows from flat file?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
if you use oracle sql*loader , how do you transform data with it during loading?
What is the use of dimensional modeling in data warehousing?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Explain what are the advantages of query studio compared to report studio?
what are the others of "bad files" and "discard files" when using sql*loader?
Explain datawarehousing?
Describe the differences between a data warehouse and data mart.
What are session timeout and application timeout?
What are the different types of data warehouses?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
