Interview Question in Data Warehousing
Interview Question :: Anybody knows about Star Schema in Data Warehouse environment
I've been given a schema for an OLTP SQL database from which I've to make the Star Schemat. I'm confused at extracting the Dimension tables, specially "Time Dimension". The Fact table has to be "Inventory_Fact".
Requirements are:
1.Name or Ids of suppliers whose orders are delayed and those whose orders are delivered in time
2.Avg. delay in number of days in shipment of orders by the company to the customer
3.Avg discards in orders by the customer
4.Avg. discards in orders supplied by the supplier to the company
5.No. of units currently in stock
6.Tot no. of orders ordered by customers against a certain time period
7.Tot. sale made by the company in a given time period against one or more products
8.Tot no. of orders placed by customers to the company
9.Which product is sold in certain region in certain time period?
10.Tot. prods ordered to company by customers
11.Tot. cost of products after shipment.
12.Profit or money gained against certain orders in specific time period
Loading ...