Understanding Source Data Objects

A source data object is the input to every map definition and defines the data to be extracted from the source. The business requirement of the map definition dictates the appropriate structure of the source data object, which can be as basic as requiring only an object definition and the fields to be used in the extract SQL specified, or quite complex containing expressions, multiple table joins, and filtering criteria.

Common Elements Used to Create Source Data Objects

Data Source

One or more record definitions joined by common fields.

Source Data Object

Enter a unique value of up to 30 characters, with no spaces or special characters. The system automatically converts the value to uppercase.

This value, along with the description from the definition page, appears at the top of each page of the Source Data Object component.