Mailings Review View Help Draw Design Layout References Cambria 16 A A A A Uab , *'APA 1 E EE Font Paragraph Question 2.3 For this question, the OLTP database is the tales of the KMOSE schema. Assume that your face table is based on the ORDER ITEMS KS transaction finchading its parent table ORDERS 2015). Also assume that the fact table has articles, D K , PCIFREE 2. for the fact Table & PCIFREE for the dimension tables, and = fused for the INTRANS parameter) for all tables a) Calculate the storage requirements following non-time dimension tables for the corresponding Star Schema model, where only identifier and decision-support type columns are included. Assume that each dimension table should be able to accommodate twice the number of current records in the corresponding OLTP tables: PRODUCT_DIM 220 based on PRODUCTS_2K15 & CATEGORIES_215. CUSTOMER_DIM_220 based on CUSTOMERS_215 SALESREP_DIM_2K20 based 00 EMPLOYEES_2K15 & DEPARTMENT_2K15 Hint: in each case first create a view that has the same columns as the given dimension table, then use this view to get an estimate of the average row length and the corresponding number of rows. b For each non-time dimension table, write a SQL DDL statement to CREATE the table. For each non-time dimension table, write a SQL OML statement to populate to it. d) Calculate the storage requirements of your fact table (ORDERS_FACT_2620) if the total number of records that the fact table should hold corresponds to 2.5 times the number of corresponding records of the operational database Write SQL DOL statement to CREATE your fact table. Your CREATE statement should include a STORAGE clause with appropriate values that reflect the concern to use disk storagt wisely fl Write a SQL statement to load the relevant data into your fact table from the relevant operational transaction event tables write 50. Do tatement to CREATE 1 Composite intex on your fact table that based on the prima key attributes of its simensionales ab X, LA LE Format Painter board Font Paragraph Chestion 2.3: For this question the OLTP database is the tables of the KMOSEI schema. Assume that your fact table is based on the ORDER MEMES 2K15 transaction (including its parent table ORDERS 2Ki. Also assume that the face table has artificial keys Da NedSize - BK; PCIFREE - 2x for the Face Table & PCTFREE-X for the dirnension tables, and i-5 fused for the INITRANS parameter) for all tables. a) Calculate the storage requirements following non-time dimension tables for the corresponding Star Schema model, where only identifier and decision support type columns are included. Assure that each dimension table should be able to accommodate twice the number of current records in the corresponding OLTP tables. O PRODUCT_DIM_220 based on PRODUCTS_2K15 & CATEGORIES 2K15. O CUSTOMER_DIM_2K20 based on CUSTOMERS_2K15 OSALESREP DIM_220 based on EMPLOYEES 2K15 & DEPARTMENT_2K15 Hint: In each case first c use this view to get an es n the average row.. s as the given dimension table, then and the corresponding number of rows. b) For each non-time dimension table, write a SQL DDL statement to CREATE the table. For each non-time dimension table, write a SQL DML statement to populate to it d) Calculate the storage requirements of your fact table (ORDERS FACT_220) if the total number of records that the fact table should hold corresponds to 2.5 times the number of corresponding records of the operational database. e) Write a SQL DDL statement to CREATE your fact table. Your CREATE statement should include a STORAGE Clause with appropriate values that reflect the concern to use disk storage wisely Write a SQL statement to load the relevant data into your fact table from the relevant operational transaction event tables B) Write a SOL DDL statement to CREATE a composite index on your fact table that is based on the primary key attributes of its dimension tables 291 words Draw Design Layout References Mailings Review View Help Cambria 16A A AA EE EE2119 M. YADA TEIE Emphasis Heading 1 1 Heading 3 1 Normal Paragraph Styles For this question, the OLTP database is the tables of the KMOSEI schema. Assume that your fact table is based on the ORDER ITEMS 2K15 transaction (including its parent table ORDERS 2K15). Also assume that the fact table has artificial keys: D BlockSize - BK; PCTFREE - 2% for the Fact Table & PCTFREE - 8% for the dimension tables; and i-5 (used for the INITRANS parameter) for all tables. a) Calculate the storage requirements following non-time dimension tables for the corresponding Star Schema model, where only identifier and decision support type columns are included. Assume that each dimension table should be able to accommodate twice the number of current records corresponding OLTP tables: O PRODUCT_DIM_220 based on PRODUCTS_2K15 & CATEGORIES 2K15. o CUSTOMER DIM 2K20 based on CUSTOMERS 2K15 OSALESREP DIM 220 based on EMPLOYEES 2K15 & DEPARTMENT 2K15 Hint: In each case first create a view that has the same columns as the given dimension table, then use this View to get an estimate of the average row length and the corresponding number of rows. b) For each non-time dimension table, write a SQL DDL statement to CREATE the table. c) For each non-time dimension table, write a SQL DML statement to populate to it. d) Calculate the storage requirements of your fact table (ORDERS_FACT_2K20) if the total number of records that the fact table should hold corresponds to 2.5 times the number of corresponding records of the operational database. DELL Mailings Review View Help Draw Design Layout References Cambria 16 A A A A Uab , *'APA 1 E EE Font Paragraph Question 2.3 For this question, the OLTP database is the tales of the KMOSE schema. Assume that your face table is based on the ORDER ITEMS KS transaction finchading its parent table ORDERS 2015). Also assume that the fact table has articles, D K , PCIFREE 2. for the fact Table & PCIFREE for the dimension tables, and = fused for the INTRANS parameter) for all tables a) Calculate the storage requirements following non-time dimension tables for the corresponding Star Schema model, where only identifier and decision-support type columns are included. Assume that each dimension table should be able to accommodate twice the number of current records in the corresponding OLTP tables: PRODUCT_DIM 220 based on PRODUCTS_2K15 & CATEGORIES_215. CUSTOMER_DIM_220 based on CUSTOMERS_215 SALESREP_DIM_2K20 based 00 EMPLOYEES_2K15 & DEPARTMENT_2K15 Hint: in each case first create a view that has the same columns as the given dimension table, then use this view to get an estimate of the average row length and the corresponding number of rows. b For each non-time dimension table, write a SQL DDL statement to CREATE the table. For each non-time dimension table, write a SQL OML statement to populate to it. d) Calculate the storage requirements of your fact table (ORDERS_FACT_2620) if the total number of records that the fact table should hold corresponds to 2.5 times the number of corresponding records of the operational database Write SQL DOL statement to CREATE your fact table. Your CREATE statement should include a STORAGE clause with appropriate values that reflect the concern to use disk storagt wisely fl Write a SQL statement to load the relevant data into your fact table from the relevant operational transaction event tables write 50. Do tatement to CREATE 1 Composite intex on your fact table that based on the prima key attributes of its simensionales ab X, LA LE Format Painter board Font Paragraph Chestion 2.3: For this question the OLTP database is the tables of the KMOSEI schema. Assume that your fact table is based on the ORDER MEMES 2K15 transaction (including its parent table ORDERS 2Ki. Also assume that the face table has artificial keys Da NedSize - BK; PCIFREE - 2x for the Face Table & PCTFREE-X for the dirnension tables, and i-5 fused for the INITRANS parameter) for all tables. a) Calculate the storage requirements following non-time dimension tables for the corresponding Star Schema model, where only identifier and decision support type columns are included. Assure that each dimension table should be able to accommodate twice the number of current records in the corresponding OLTP tables. O PRODUCT_DIM_220 based on PRODUCTS_2K15 & CATEGORIES 2K15. O CUSTOMER_DIM_2K20 based on CUSTOMERS_2K15 OSALESREP DIM_220 based on EMPLOYEES 2K15 & DEPARTMENT_2K15 Hint: In each case first c use this view to get an es n the average row.. s as the given dimension table, then and the corresponding number of rows. b) For each non-time dimension table, write a SQL DDL statement to CREATE the table. For each non-time dimension table, write a SQL DML statement to populate to it d) Calculate the storage requirements of your fact table (ORDERS FACT_220) if the total number of records that the fact table should hold corresponds to 2.5 times the number of corresponding records of the operational database. e) Write a SQL DDL statement to CREATE your fact table. Your CREATE statement should include a STORAGE Clause with appropriate values that reflect the concern to use disk storage wisely Write a SQL statement to load the relevant data into your fact table from the relevant operational transaction event tables B) Write a SOL DDL statement to CREATE a composite index on your fact table that is based on the primary key attributes of its dimension tables 291 words Draw Design Layout References Mailings Review View Help Cambria 16A A AA EE EE2119 M. YADA TEIE Emphasis Heading 1 1 Heading 3 1 Normal Paragraph Styles For this question, the OLTP database is the tables of the KMOSEI schema. Assume that your fact table is based on the ORDER ITEMS 2K15 transaction (including its parent table ORDERS 2K15). Also assume that the fact table has artificial keys: D BlockSize - BK; PCTFREE - 2% for the Fact Table & PCTFREE - 8% for the dimension tables; and i-5 (used for the INITRANS parameter) for all tables. a) Calculate the storage requirements following non-time dimension tables for the corresponding Star Schema model, where only identifier and decision support type columns are included. Assume that each dimension table should be able to accommodate twice the number of current records corresponding OLTP tables: O PRODUCT_DIM_220 based on PRODUCTS_2K15 & CATEGORIES 2K15. o CUSTOMER DIM 2K20 based on CUSTOMERS 2K15 OSALESREP DIM 220 based on EMPLOYEES 2K15 & DEPARTMENT 2K15 Hint: In each case first create a view that has the same columns as the given dimension table, then use this View to get an estimate of the average row length and the corresponding number of rows. b) For each non-time dimension table, write a SQL DDL statement to CREATE the table. c) For each non-time dimension table, write a SQL DML statement to populate to it. d) Calculate the storage requirements of your fact table (ORDERS_FACT_2K20) if the total number of records that the fact table should hold corresponds to 2.5 times the number of corresponding records of the operational database. DELL