Difference between slicing and dicing with example?
Answers were Sorted based on User's Feedback
Answer / chandni
Slicing means filtering of dimensional data .
Dicing means viewing the data through different dimensions.
| Is This Answer Correct ? | 12 Yes | 6 No |
Answer / edith herman
slicing and dicing refers to the ability to combine and re-
combine the dimensonsions to see different slice of the
information.
| Is This Answer Correct ? | 7 Yes | 15 No |
Why null values are mapped as 0 in fact tables?
Explain why are oltp database designs not generally a good idea for a data warehouse?
List down some of the real time data-warehousing tools?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
Why joiner transformation does not allow the aggregator transformation and expression transformation to join
Explain the difference between data ware house & data mart?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
When should you use a STAR and when a SNOW-FLAKE schema?
What are the advantages and disadvantages of reporting directly against the database?
What are CUBES?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Which are the olap tools available that are supported by oracle?