1. Analytical Application Infrastructure User Guide
  2. Data Management Framework
  3. Data Mapping
  4. Creating Data Mapping Definition

Creating Data Mapping Definition

This option facilitates you to extract data from data sources and load them to a table. The data source and target can be RDBMS table, HDFS-HIVE table, or Flat File. It can also be a WebLog source and HDFS-Hive target. You can Load data incrementally from any data source to a table based on certain criteria.

Note:

If DB2 is selected as the source database, map data from Table to File (T2F) and then File to Table (F2T).

Processing on Datatypes TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE is not supported, even though source model generation is supported for those datatypes.

Defining Data Mapping involves the following steps:

  • Specifying Data Mapping Details
  • Selecting Model
  • Defining Data Mapping to Table or File
  • Defining Mapping Properties
  • Associating DQ rules to the Data Mapping Definition