How to add a multiphase data pump transformation function using an ActiveX script (Enterprise Manager)
To add a multiphase data pump transformation function using an ActiveX script
- After activating the multiphase data pump feature and configuring your source and destination connections, click the Transformations tab.
- In the Phases filter list, click the data pump phase you want to add.
The Phases filter list displays all the transformations configured for a specific data pump phase. By default, the Row transform phase is selected.
- Do one of the following:
- If the columns you want are not already mapped to another transformation, click New.
- If the columns you want are already mapped, click on the mapping line for the transformation, click Delete, and then click New.
- If the columns you want are not already mapped to another transformation, click New.
- In the Create New Transformation dialog box, click ActiveX Script.
- Click the Source Columns tab, and then use the arrow buttons to select columns for the transformation.
- Click the Destination Columns tab, and then use the arrow buttons to include a column in the transformation.
- Click the General tab, click Properties, and then click the Phases tab.
- Select the data pump phases for which you will be adding Microsoft® ActiveX® script functions, and then for the selected phases, type the names of those functions in their respective boxes.
- In the ActiveX Script text box, enter the ActiveX script code for each function.
The function names specified in the ActiveX Script text box must match those entered on the Phases tab.