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? |
|
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. |