Creating a Data Transformation with the Convert Mappings to ETL Wizard

You can create a data transformation from an existing PDM-PDM mapping with the Convert Mappings to ETL Wizard. It helps you set up your transformation process with PDMs connected to it as input and output sources, along with basic data transformation diagrams with the appropriate data inputs and outputs, and appropriate actions.

1. Select Tools > Convert Mappings to ETL Wizard to launch the Convert Mappings to ETL Wizard, and click Next to go to the next step.
   
   
   
2. The Database Selection page lets you specify the target database containing mappings. You can:

   • Create a new database in your DMM by entering a new name in the Target Database field.

   • Select an existing database from the list of available database by clicking the Select a Database tool.

   Make your selection, and then click Next.

3. The Target Models page lets you select the target models from which to extract the mapping information, and which will serve as the targets for the transformation. Any models attached to the previously selected database are selected by default. You can click the Open Model tool to browse for other model files.

   Make your selection, and then click Next.

4. The Transformation Process page lets you specify the transformation process to use for the data to be transformed. You can:

   • Create a transformation process by entering a new name in the Transformation Process field, and selecting a type to identify your transformation engine.

   • Select an existing transformation process by clicking the Browse tool.

   Make your selection, and then click Next.

5. The Transformation Tasks page lets you specify the task(s) that will contain the details of your transformation. You can:

   • Create a single task for all the mapped tables in the same data transformation diagram.

   • Select an existing task.

   • Create a separate task and a data transformation diagram for each mapped table, and manage them individually.

   Make your selection, and then click Next.

6. The Target Objects page lets you select the target tables that will contain the transformed data.

   Make your selection, and then click Next.

7. The last page of the wizard summarizes the objects that will be created:

   When you click Finish the wizard creates:

   • A data movement diagram containing a transformation process connected to its input and output sources.

   • One or more data transformation diagrams containing data inputs and outputs, and any appropriate actions retrieved from the mapping conversion. Press Ctrl and double-click the transformation process to open diagrams.

     
     
     

• Mapping Conversion
  A PDM-PDM mapping is specified in a query or a textual expression defined in a target table, and from which its source(s) and associated model(s) can be retrieved.