Survey Jobs

This table provides answers to questions about survey jobs.

Question	Answer
Where are the Survey-related jobs in the dsx files? After import, where can I find the Survey jobs in the DataStage Project?	Survey jobs are present in OWE and MDW modules of HCM warehouse. In OWE module, there are some D00 jobs which reads the flat file data as source and loads the R00 tables. These jobs can be located in OWE.dsx and after the import, the jobs will be present under the OWE_E\HCM\D00\Base\Load_Tables\Server category. In the MDW module, the R00 tables are used as source and it load the Survey Dimension tables. These jobs can be located in WHR_WORKFORCE_PROFILE_MART_E.dsx file and after the import, the jobs will be present under the \HCM_E\WORKFORCE_PROFILE_MART\Survey\OWE_To_MDW\Dimensions\Base\Load_Tables\Server category. In EPM, the dimension D_EMPL_JOB from HCM warehouse is designed as a type 2 slowly changing dimension and all the other dimension loads are Type 1. However, the lookup operation supports Type 2 (for example, whenever there is lookup on other dimension, it will have effective dated logic).
What are the required steps in a Survey load?	Run Survey Setup ETL: These are the jobs that read the source flat files or the temp tables and loads the R00/D00 tables. These jobs can be located in OWE_E.dsx files and it will be present under the path \OWE_E\HCM\D00\Base\Load_Tables\Server category. Run Survey Load ETL Batch: These are the jobs that read the data loaded in the above step and loads the F00 tables. These jobs can be located in OWE.dsx files and it will be present under the path \OWE_E\HCM\F00\Base\Load_Tables\Server category. Load Employee level Competencies: These jobs loads the Competency details of the employee from the OWS tables. These jobs can be located in OWE.dsx files and it will be present under the path \OWE_E\HCM\F00\Base\Load_Tables\Server category.
What are the prerequisites for loading the Survey module?	OWE Survey jobs are present under the HCM warehouse. These jobs use Flat files as sources. These source flat files should be present in the Project home directory and the environmental parameter $SOURCE_FILE_DIR should have the directory path of these survey flat files. If the DataStage server is on Windows, then the survey jobs have to be modified by accessing the Sequential file stage and changing the Line Termination to DOS Style (CR LF). And then save the job, Compile and run the same.

Question

Answer

Where are the Survey-related jobs in the dsx files?

After import, where can I find the Survey jobs in the DataStage Project?

Survey jobs are present in OWE and MDW modules of HCM warehouse.

In OWE module, there are some D00 jobs which reads the flat file data as source and loads the R00 tables. These jobs can be located in OWE.dsx and after the import, the jobs will be present under the OWE_E\HCM\D00\Base\Load_Tables\Server category.

In the MDW module, the R00 tables are used as source and it load the Survey Dimension tables. These jobs can be located in WHR_WORKFORCE_PROFILE_MART_E.dsx file and after the import, the jobs will be present under the \HCM_E\WORKFORCE_PROFILE_MART\Survey\OWE_To_MDW\Dimensions\Base\Load_Tables\Server category.

In EPM, the dimension D_EMPL_JOB from HCM warehouse is designed as a type 2 slowly changing dimension and all the other dimension loads are Type 1. However, the lookup operation supports Type 2 (for example, whenever there is lookup on other dimension, it will have effective dated logic).

What are the required steps in a Survey load?

Run Survey Setup ETL: These are the jobs that read the source flat files or the temp tables and loads the R00/D00 tables. These jobs can be located in OWE_E.dsx files and it will be present under the path \OWE_E\HCM\D00\Base\Load_Tables\Server category.
Run Survey Load ETL Batch: These are the jobs that read the data loaded in the above step and loads the F00 tables. These jobs can be located in OWE.dsx files and it will be present under the path \OWE_E\HCM\F00\Base\Load_Tables\Server category.
Load Employee level Competencies: These jobs loads the Competency details of the employee from the OWS tables. These jobs can be located in OWE.dsx files and it will be present under the path \OWE_E\HCM\F00\Base\Load_Tables\Server category.

What are the prerequisites for loading the Survey module?

OWE Survey jobs are present under the HCM warehouse. These jobs use Flat files as sources. These source flat files should be present in the Project home directory and the environmental parameter $SOURCE_FILE_DIR should have the directory path of these survey flat files.

If the DataStage server is on Windows, then the survey jobs have to be modified by accessing the Sequential file stage and changing the Line Termination to DOS Style (CR LF). And then save the job, Compile and run the same.