Skip to Main Content
Return to Navigation

Verifying ETL Components Have Imported Properly

After you have finished configuring DataStage for EPM and imported all of the appropriate *.dsx files (which include different ETL components) you must verify that all the necessary components have been imported properly. This must be performed prior to running any ETL setup jobs.

Verifying Routines

Perform the following steps to verify that your ETL routines are present:

  1. In DataStage Designer, attach to your project and expand the Routines node in the left navigation panel of the window.

  2. Verify that the object, EPM_Routines, is present in the list of routines.

    If this object does not exist in the list, your import of the Common_Utilities.dsx file was unsuccessful. You must re-import the *.dsx file.

Verifying Shared Containers

Perform the following steps to verify that your shared containers are present:

  1. In DataStage Designer, attach to your project and expand the Shared Containers node in the left navigation panel of the window.

  2. Verify that the objects, Incremental_Logic and Language_Swap, are present in the list of shared containers. The Incremental_Logic object should also contain six components and Language_Swap should contain one.

    If these objects do not exist in the list, your import of the Common_Utilities.dsx file was unsuccessful. You must re-import the *.dsx file.

Verifying ETL Jobs

Perform the following steps to verify that your ETL jobs are present:

  1. In DataStage Designer, attach to your project and expand the Jobs node in the left navigation panel of the window.

  2. Expand each of the sub-folders in the Jobs node, such as Common_Dimensions,Global_Dimensions_E, and Shared_Lookups, and verify that each folder has the requisite ETL jobs in it.

    The number of jobs present in each sub-folder vary depending on the product you are implementing.

  3. Repeat the first two steps for each product and related project ( for example HCM Warehouse).