Developer Transformation Guide

Back Next

Logical Data Object Mapping

The logical data object mapping contains the following objects:

Employee table: Input relational table of employee data from the Human Resources database.

Salary table: A table in the Payroll database that contains the employee salary and hire date. The database is an Oracle database.
SQL transformation: Transformation that retrieves the hire date and salary for each employee row. The transformation connects to a Payroll database and runs an SQL query against the Salary table in the database.
Logical data object: Contains the combined view of the employee and the salary data. The logical data object receives the output from the SQL transformation.
SQLErrors file: The SQLErrors file is flat file that contains any SQL error from the database. The Data Integration Service writes at least one row to the SQLErrors file for each input row. If no SQL errors occur, the SQLError column contains NULL. Review the SQLErrors file to troubleshoot errors.