What Oracle features can be used to optimize my Warehouse
system?
- 1 Answers
- 4908 Views
- I also Faced
- E-Mail Answers
Answer / abhishek soni
Partition table,bitmap index,sequence,table function,sql
loader ,function like cube,roll_up etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
Suppose we want to display zero when null values coming to report how can we do that?
What is multi-dimensional analysis?
Explain the versions of reportnet?
What is application.cfm?
Explain degenerate dimension table?
what is difference between scd2 and scd3
Code the tables statement for a single-level (most common) frequency?
Explain a linked cube?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
Explain datawarehousing?
Explain difference between snow flake and star schema.
Why is dimensional normalization not required?
Teradata 
