TXT Format

Once the mappings are considered 'approved for coding', you can export the mappings as coding requirements to automatically generate ETL/ELT jobs for tools, such as Informatica PowerCenter, IBM DataStage, Big Data, and Talend.

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, right-click a project.
    Etl Export
  3. Click Execute Connector.
    The Connectors page appears.
    Etl Export Window
  4. On the Connectors page, go to relevant tab based on the export requirements and select an ETL tool.
    The screenshot below displays Talend tab as an example.
    Etl Export Talend Cat
  5. Click Icon Run Con.
    The Multi Mapping page appears.
    Multi Mapping
  6. Select the required mappings and click Icon Etl Engineering Export.
    The following notification appears.

    7. Etl Exported

  7. Click Download File.
    Selected projects and maps are exported and downloaded as a ZIP file. Unzip this file to use mapping specifications in the TXT format.