Export Specifications

Oracle Fusion Data Intelligence uses the Autonomous Data Warehouse as its default data warehouse. Using export specification, Data Augmentation Scripts provides a way to control the visibility of the datasets in Autonomous Data Warehouse.

Export specification is essential in ensuring that only the necessary datasets are exposed to the Autonomous Data Warehouse. Limiting access to certain data or functionality enables you to protect critical parts of the system from unintended use or modification, reducing the risk of errors or security vulnerabilities. This separation helps maintain system integrity, enhances modularity, and makes it easier to manage, test, and update the code over time without disrupting the broader system.

Data Augmentation Scripts provides the following export specifications:

• PRIVATE: Typically used for creating stage or intermediate tables. These tables aren't exported to the Autonomous Data Warehouse.

  A PRIVATE VERSIONED dataset stores data temporarily for preprocessing or transformation before updating a permanent dataset.

  DEFINE PRIVATE VERSIONED DATASET TEMP_DAILY_SALES  
      ROWSOURCE SALES;  
      // Temporary calculations  
      THIS[PRODUCT_ID]       = SALES.PROD_ID;  
      THIS[SALES_AMOUNT]     = SALES.SALES_AMOUNT;
      THIS[DISCOUNTED_SALES] = THIS[SALES_AMOUNT] - (THIS[SALES_AMOUNT]* 0.10);
   
  END  
  
  DEFINE VERSIONED DATASET DW_MONTHLY_SALES
       ROWSOURCE TEMP_DAILY_SALES;
  
       // Aggregate temporary data into a permanent dataset
        THIS[PRODUCT_ID]       = TEMP_DAILY_SALES.PRODUCT_ID;
        THIS[TOTAL_SALES]     = SUM(TEMP_DAILY_SALES.DISCOUNTED_SALES);
       GROUPBY[PRODUCT_ID];
       PRIMARYKEY[PRODUCT_ID];
   
  END
  

  The TEMP_DAILY_SALES dataset performs temporary calculations on SALES, where PRODUCT_ID isn't unique. This dataset has no primary key and is still allowed. No Primary Key declaration is required. It's then used in DW_MONTHLY_SALES to aggregate the data into a permanent dataset with a PRIMARYKEY on PRODUCT_ID.

• PROTECTED: Typically used for internal housekeeping or backing up a VIEW dataset. These datasets are exported to the Oracle Autonomous Data Warehouse, but they aren't visible to end users.
• PUBLIC: Default export specification for a dataset. These datasets are exported in the Autonomous Data Warehouse and are visible to business users for building insights.