Skip to Main Content
Return to Navigation

Project Creation, Import, and Export

This table provides answers to project creation, import, and export questions.

Question

Answer

What are the different methods of maintaining projects if I have jobs that source from more than one warehouse?

The EPM ETL design enables jobs to distribute across multiple projects or only a single project. However, the following are some of the options to create projects based on your needs.

  • Option 1: One project per EPM warehouse

    If you have more than one EPM warehouse, you can create one project per warehouse and one project for all the jobs related to Common jobs and Global Dimensions. For example, if you have HCM and FMS warehouse then there are three projects created for HCM, FMS and Common. The J_Dim_PS_D_PERSON is a part of Global Dimensions and this job must be triggered in Common project whereas the corresponding Hash Load jobs have to be triggered in HCM and FMS projects as well.

  • Option 2: All EPM warehouses in a single project

    You can have one single project for all the jobs for all the EPM warehouses, Common jobs and Global Dimensions. If you maintain only one project for all the warehouses (HCM, FMS and Common jobs) you need to run the Global Dimensions, Local Dimensions (HCM, FMS), SKU based dimensions and there is no need to run the Hash Load jobs after the first run.

    For this option, there is a possibility of reaching a maximum number of files limit for directories in some OS platforms. Please verify with system administrators before proceeding with this option.

What configurations must I perform after creating the projects?

Projects must be created from the DataStage Administrator.

See Setting Up DataStage Projects.

How do I import a project? How do I verify a successful import?

For more information about importing a project, see section 2-5 of the Configuring IBM WebSphereDataStage document.

See Setting Up DataStage Projects.

What are the DataStage categories (folders) and sub-categories that I will see after project import?

For more information about the DataStage categories available, see the topic 'Understanding the Project Structure' in this document.