Which kind of index is preferred in DWH?
- 1 Answers
- 7888 Views
- I also Faced
- E-Mail Answers
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 |
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
How to add a number to a macro variable?
How to pivot row data using informatica?
Explain a relation schema and a relation?
Explain piconet?
Is union transormation is active transformation?
difference between For each and for all
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.
What is edw?
what is hybrid schema
Why null values are mapped as 0 in fact tables?
what are the major three types of modeling used?
0 Answers InfoAxon Technologies,
Teradata 
