Using Data Mapper
Data Mapper is a visual data-mapping tool used for mapping elements in advanced data integration projects. This tool allows you to specify source and target schemas and to map data fields from source schema to target schema.
You can use the Data Mapper tool to map source schema elements to target schema elements. You can map one source schema element to a target schema element directly by drag and drop method. Additionally, this tool also offers certain mapping functions using which you can map source and target schema elements. Furthermore, the Data Mapper supports multiple source and target schemas. This implies that you can select more than one schema at a time, both at the source and the target end. This facilitates mapping of multiple source and target schema elements.
Following are the major subsections:
Section Name | Description |
---|---|
Introduces Data Mapper user interface. | |
Learn how to map elements in the Data Mapper. | |
Introduction to Data Viewer and its usage. | |
Know how to view mapping activity in PDF format. | |
Learn how to view and manage mapping activity in read-only mode. | |
Introduces Splitting concept and step-by-step instructions to split source data are also provided. | |
Introduces Splitter XPath concept and instructions to set Splitter XPath are also provided. | |
Step-by-step instructions to split source data using Quick Splitting, viewing and removing Splitter XPath. | |
Introduces Merger XPath concept and instructions to set, view, and remove Merger XPath are also provided. | |
Learn how to assign streams to the root element of the target schema structures. | |
Learn how to remove mapping associated with a particular element. | |
Introduction to Context Schema and its usage to map context variable. | |
Know about various inbuilt mapping functions available in the Data Mapper. Learn how to map source and target schema elements using mapping functions. | |
Learn how to fetch data from database using various DB Mapping functions. | |
Step-by-step instructions to map elements using Textual Rules. | |
Step-by-step instructions to add and edit Namespace in XSL. | |
Introduction to XSL template and step-by-step instructions to create XSL template using Mapping Rules and XSL rules are also provided. | |
Introduces Global Variable concept, declaration, managing global variable from Parameters panel, and mapping global variable to target element. | |
Introduces Local Variable concept, declaration, managing local variable from Parameters panel, and mapping local variable to specific target element. | |
Introduces Custom Method concept, declaration, and mapping custom method to target element. | |
Learn how to load custom methods dynamically. | |
Introduction to Key Function. | |
Learn how to declare connection info variable. | |
Learn how to set the properties and add comments to the target element. | |
Learn how to filter elements or attributes appearing in the target XML using Apply Filter check box. | |
Learn how to create and remove the clone of a target element. | |
Introduction to CData and step-by-step instructions to add CData are also provided. | |
Learn how to remove schema from source or target panels. | |
Learn how to add custom XSL code to a target element. | |
Learn how to select the root of a schema. | |
Learn how to add a namespace prefix to a target element. | |
Learn how to exclude namespace prefix from the Output screen. | |
Learn how to select extension type element. |