Please use PL/SQL

please need it so fast

I will post the second part of the question

CCDS-221 Data Warehouse Answer the following questions 1. Use the CREATE and SELECT statements to create one-column temporary table T_ORDER_DATE (ORDER_DATE DATE) containing ORDER_DATE values (formatted as DD-MM-YYYY) from the OE.ORDERS table. 2. Display the whole content of T_ORDER_DATE including the ROWID pseudo-column. Note that ROWID values are all distinct (even for identical rows). Check the duplicates using one of the following 2 methods: 3. Write a SELECT to display the number of distinct values (You should get 70). 4. Display the number of occurrences of each ORDER_DATE value. Deduplicate. The Deduplication is a frequent ETL task to prepare Non-Redundant data for loading dimensions and/or facts. It keeps a single value of each repeated value. 5. Remove duplicates from T_ORDER_DATE: (you can use ROWID). If the operation is tedious, skip to the next question to do it otherwise. 6. The T_ORDER_DATE table could be created (from the beginning) without redundant rows in order to avoid deduplicating it. DROP T_ORDER_DATE. Rewrite your answer to question 1 to obtain directly distinct values of dates in T_ORDER_DATE. 7. Whatever the method you have used so far, you have deduplicated table T_ORDER_DATE. Create a temporary table (assumed in the staging area) called T_DATE. Structure of the table T_DATE to create: T_DATE( ORDER_DATE DATE, Day No NUMBER (1), Day_Name CHAR(10), Month_NO NUMBER (2) Month_Name CHAR(10), Quarter NUMBER (1) YYear NUMBER (4) ) You will need T_DATE to populate the TIME Dimension of your DW. 8. Populate the T_DATE table from T_ORDER_DATE (use the built-in functions TO_CHAR for extracting the Date elements and TO_NUMBER to convert into NUMBER). CCDS-221 Data Warehouse Answer the following questions 1. Use the CREATE and SELECT statements to create one-column temporary table T_ORDER_DATE (ORDER_DATE DATE) containing ORDER_DATE values (formatted as DD-MM-YYYY) from the OE.ORDERS table. 2. Display the whole content of T_ORDER_DATE including the ROWID pseudo-column. Note that ROWID values are all distinct (even for identical rows). Check the duplicates using one of the following 2 methods: 3. Write a SELECT to display the number of distinct values (You should get 70). 4. Display the number of occurrences of each ORDER_DATE value. Deduplicate. The Deduplication is a frequent ETL task to prepare Non-Redundant data for loading dimensions and/or facts. It keeps a single value of each repeated value. 5. Remove duplicates from T_ORDER_DATE: (you can use ROWID). If the operation is tedious, skip to the next question to do it otherwise. 6. The T_ORDER_DATE table could be created (from the beginning) without redundant rows in order to avoid deduplicating it. DROP T_ORDER_DATE. Rewrite your answer to question 1 to obtain directly distinct values of dates in T_ORDER_DATE. 7. Whatever the method you have used so far, you have deduplicated table T_ORDER_DATE. Create a temporary table (assumed in the staging area) called T_DATE. Structure of the table T_DATE to create: T_DATE( ORDER_DATE DATE, Day No NUMBER (1), Day_Name CHAR(10), Month_NO NUMBER (2) Month_Name CHAR(10), Quarter NUMBER (1) YYear NUMBER (4) ) You will need T_DATE to populate the TIME Dimension of your DW. 8. Populate the T_DATE table from T_ORDER_DATE (use the built-in functions TO_CHAR for extracting the Date elements and TO_NUMBER to convert into NUMBER)