Skip to Main Content
Return to Navigation

Data Mart Source ETL Jobs

For Workforce Rewards Data Mart, the required ETL (extract, transform and load) jobs are premapped from your HRMS tables. You use these to import data into the Operational Warehouse source tables (OWS). From the OWS tables you use ETL to load the data into the operational warehouse enriched (OWE) tables (F00s, D00s, and R00s). Some of the Data Mart dimensions use the imported information from these data warehouse tables. You also use your Workforce Rewards system to enrich and transform this imported data into new data, such as scenario results. This new data is also stored in data warehouse tables, and some of the Data Mart dimensions use this new information.

Warning! Any changes you make to the delivered data warehouse tables may affect Application Engine processes, PeopleCode processing, and pages throughout your system. You must evaluate and execute these types of changes very carefully.

ETL jobs are delivered with your Workforce Rewards system in an IBM WebSphere DataStage Project. We designed these jobs with, and they are intended for use with, IBM WebSphere DataStage. IBM WebSphere DataStage is the ETL tool delivered with EPM. If you choose to use an ETL tool other than IBM WebSphere DataStage, use the delivered ETL jobs as templates and modify them as needed.