ETL Jobs

Once the mappings are considered 'approved for coding', you can export the mappings as coding requirements to automatically generate ETL/ELT jobs. The ETL jobs can be generated for tools, such as Informatica PowerCenter, IBM DataStage, Microsoft SQL Server SSIS, and Talend.

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click the required map.
  3. The Mapping Specification grid appears.

  4. Click .
  5. The Export Window page appears.

  6. Click the ETL Engineering tab.
  7. Select the required ETL tool and click .
  8. The Multi Mapping page appears.

  9. Select the mapping and click .
  10. The following notification appears.

  11. Click the Download File hyperlink.

The mapping specification is exported.