Oracle Cloud Infrastructure Documentation

Create Dataset Augmentation Type

You may require a dataset to be copied into a target warehouse table, as is, and then perform semantic model extension on it. In such cases, create an input dataset.

This dataset isn’t associated with any other augmentations. Based on the incremental schedule, the data in this dataset gets refreshed during scheduled pipeline refresh. But unlike other augmentations, this augmentation isn’t linked to other augmentations, and you can’t change the attributes as dimension or measure. This dataset isn’t associated with any subject area because it copies the dataset from source and creates a warehouse table. You can perform semantic model extension after the table is created. To use this dataset to build the joins or incorporate an object from the dataset into your semantic model, you must run an incremental load prior to using it because the incremental load populates the dataset.

  1. In step 1 of the Data Augmentation wizard, select Dataset in Augmentation Type to add a new warehouse table.

    Create Dataset augmentation type wizard

  2. Select Supplemental Data in Source Dataset Type.
  3. In Pillar, select a product pillar; for example, Enterprise Resource Planning.
  4. In Source Table Type, specify the source table type using either of the options:
    • Select System Provided and then in Source Table, select a table whose attributes you want to add into the input dataset.
    • Select Customer Provided and then in Source Table, enter the name of the table whose attributes you want to add into the input dataset
  5. Optional: Select the Versioned Dataset check box to enable full load of the source table data everytime and then click Next.
  6. In step 2 of the wizard, select the check box for the attributes from the source table to add to the target table, and then click Next.
  7. In step 3 of the wizard, select the settings for the selected columns, and then click Next.
  8. In step 6 of the wizard, provide the following details and click Finish to save and schedule your data augmentation pipeline job:
    1. Provide a name and description for your augmentation.
    2. Enter a suffix for the target table name using underscore in place of spaces between words and don’t use special characters; for example, Customer_Class_D. The augmentation process automatically creates the target table name.
    3. Specify the options to save the data augmentation pipeline job without executing it, or schedule the execution date and time, or execute it immediately.