Create a Read Transformation

Create the transformation from a data object in the Model repository.

Perform the following steps to create a Read transformation from a data object in the Model repository:

1. 1. Open the mapping in the editor.
2. 2. Drag a data object from the Object Explorer to the editor view.
3. 3. Select Read and click OK.
The Read transformation in the mapping contains the ports and properties of the data object.

Create the transformation using the mapping editor.

Use this method if you want to configure detailed Read transformation settings. You can also use this method if you want to base a Read transformation on a parameter.

To create a Read transformation in the mapping editor, see Creating a Read Transformation in the Mapping Editor.

Creating a Read Transformation in the Mapping Editor

1. Choose one of the following methods to create a Read transformation:
• - Right-click in the mapping editor and select Add Transformation.
The Add Transformation dialog box opens.
Select Read transformation and click Next.
• - Scroll down in the mapping palette to locate and double-click the Read transformation icon.
The following image shows the Read transformation icon:

The New Read Transformation dialog box opens.
2. To use a flat file, a relational resource, or a customized data object as the source, perform the following steps:
1. a. Select Physical Data Object as the data object type.
2. b. Click Browse to select a flat file, a relational resource, or a customized data object.
The Select Data Object window opens.
3. c. Select a data object and click OK.
4. d. Optionally, configure the transformation to fetch data object columns from the source at run time. Select At run-time, get data object columns from data source.
The Data Integration Service refreshes column metadata for the Read transformation when the mapping runs.
3. To use a parameter as the source, perform the following steps:
1. a. Select Create using a parameter.
2. b. Click New to create a new parameter, or click Browse to select an existing parameter.
3. c. Select a parameter and click OK.
4. d. Optionally, configure the transformation to fetch data object columns from the source at run time. Select At run-time, get data object columns from data source.
The Data Integration Service refreshes column metadata for the Read transformation when the mapping runs.
4. To use a logical data object as the source, perform the following steps:
1. a. Select Logical Data Object as the data object type.
2. b. Click Browse to select a data object, and then click OK.
5. Optionally, type a name for the Read transformation.
6. Click Finish.