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.
Perform the following steps to verify that your ETL routines are present:
In DataStage Designer, attach to your project and expand the Routines node in the left navigation panel of the window.
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 ETL Jobs
Perform the following steps to verify that your ETL jobs are present:
In DataStage Designer, attach to your project and expand the Jobs node in the left navigation panel of the window.
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.
Repeat the first two steps for each product and related project ( for example HCM Warehouse).