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

Creating Data Mapping Definition

Data Mapping Definitions enable data extraction from data sources and data loading into tables.

Creating Data Mapping Definition enables users to extract data 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<more Inputs required>. 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 <is this UI element or codeph?>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 :

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