Using DataStage BASIC
If you need to load data from a non-PeopleSoft source, you usually do not have to perform any programming tasks: you can use the delivered transforms and routines, using the delivered jobs and sequences as templates. For more complex jobs, you can use DataStage BASIC to:
Define custom routines.
Define custom transforms.
Define derivation, expressions, and constraints in the transformer stage.
Define before-job or after-job subroutines.
Define job control routines.
PeopleSoft provides ETL jobs for loading data from PeopleSoft applications into EPM. Some of the PeopleSoft jobs use custom routines using DataStage BASIC.