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 |
Explain what is fact less fact table? Where you have used it in your project?
How to provide security in frame work manager for a query subject?
What is "method/1"?
What are aggregate transformation?
What are modeling tools available in the market?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
What are components of report studio?
What is difference macros and prompts?
Explain degenerate dimension table?
What is surrogate key? Where we use it? Explain with examples.
Explain why fact table is in normal form?
What are cursors?