Loading Reference Data

During Data Normalization, OTBI-Enterprise Implementors create, generate, and execute a Domain-only Load Plan to load reference data from the cloud data source. For example, reference data might include lists of valid values for Gender, Department, Salary-scale, and Age-range.

To load reference data:
  1. Create a Domain-only Load Plan:
    1. In Configuration Manager, select the Manage Load Plans link on the Tasks pane, then click the Add icon to create a new load plan.
      Description of GUID-2B424A0E-53BF-467F-9A1C-0A087C37C56C-default.gif follows
      Description of GUID-2B424A0E-53BF-467F-9A1C-0A087C37C56C-default.gif
      • In the Name field, specify a short name to identify the load type, source, and version. For example, enter Taleo_Domain_Only_Plan.

      • (Optional) In the Description field, specify a short string that identifies the Load Plan in Configuration Manager.

      • In the Load Plan Type list, select Domain-Only Extract and Load (SDE and SIL).

      • In the Source Instances list, select the cloud data source from which you want to extract reference data.

    2. Complete the Enter Name and Description fields.
      Description of GUID-259FB20A-25C7-482D-962F-7880644C5A46-default.gif follows
      Description of GUID-259FB20A-25C7-482D-962F-7880644C5A46-default.gif
    3. Click Next to display the Select Fact Groups page.
    4. Select the Selected box next to each fact group that you want to load, then save the details.Description of GUID-936A9C99-9D0B-4E28-92BB-E481B8BA4390-default.gif follows
      Description of GUID-936A9C99-9D0B-4E28-92BB-E481B8BA4390-default.gif
  2. Generate the new Load Plan:
    1. Select the Manage Load Plans link on the Tasks bar, highlight the Domain-Only Extract and Load (SDE and SIL) load plan, then click Generate.
      Description of GUID-845F9376-CE3A-446C-8DA6-CE551E81AE1E-default.gif follows
      Description of GUID-845F9376-CE3A-446C-8DA6-CE551E81AE1E-default.gif
    2. Monitor the progress of this load plan using the Generation Status and Execution Status icons.
      Description of GUID-D63E8074-1AC0-41F0-8EDA-6E24B2C98FBE-default.gif follows
      Description of GUID-D63E8074-1AC0-41F0-8EDA-6E24B2C98FBE-default.gif
      • If the Generate process succeeds, then continue to Step 3.

      • If the Generate process fails, then:

        • Use Manage Load Plans toolbar options to diagnose issues.

        • Resolve the issues.

        • Click Generate and monitor the process again.

        • Repeat this process until the Generate succeeds, then skip to Step 3.

  3. Execute the new Load Plan:
    1. At the Manage Load Plans page, highlight the Domain-Only Extract and Load (SDE and SIL) load plan, and click Execute (Execute Load Plan icon
      Description of GUID-1F9BB2BA-A4C1-4A00-B5E1-6919BFBAE56D-default.gif).
    2. Monitor the Execute process.
      Description of GUID-0F0ACF00-D327-4BA3-9390-B3042347DFE4-default.gif follows
      Description of GUID-0F0ACF00-D327-4BA3-9390-B3042347DFE4-default.gif
      • If the Execute process succeeds, then you have completed the configuration.

      • If the Execute process fails, then:

        • Use the ODI Console to diagnose issues.

        • Resolve the issues.

        • Click Execute and monitor the process again.

        • Repeat this process until the Execution succeeds.