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 |
Start a batches with in a batch?
what is a hot file, why we need in datawarehousing, where we used in general
How we are using this function?
How can we transform row to column?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain difference between data ware house & data mart?
What are the different problems that ?Data mining? can solve?
What a static and local variable?
Explain piconet?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Where the applications and where
Explain in detail abt measure objects? And what is the use of it? How to create it?