Question: A manufacturing company has a huge sales network. To control the sales, it is divided into regions. Each region has multiple zones.
0

Each zone has different cities. Each sales person is allocated different cities. The objective is to track sales figure at different granularity levels of region and to count no. of products sold. Design a star schema by considering granularity levels for region, sales person and time. Convert the star schema to snowflake schema.

Mumbai University > Computer Engineering > sem 8> data warehouse and mining

Marks: 10M

mumbai university • 217 views
ADD COMMENTlink
modified 6 weeks ago by gravatar for RB RB100 written 7 weeks ago by gravatar for Ankit Pandey Ankit Pandey60
0

enter image description here

ADD COMMENTlink
modified 6 weeks ago by gravatar for Yashbeer Yashbeer160 written 6 weeks ago by gravatar for Ankit Pandey Ankit Pandey60
Please log in to add an answer.