Data Services Integrator transforms are used to enhance your data integration projects beyond the core functionality of Platform transforms. In your projects, you encounter XML data with repeated nodes, hierarchy data, or sources of data where there are either too many fields or not enough fields. You find that the Platform transforms do not provide enough flexibility and so you turn to the Data Services Integrator-specific transforms for assistance.
Data Services Integrator transforms perform key operations on data sets to manipulate their structure as they are passed from source to target.
Besides Table_Comparison, History_Preserving, and Key_Generation, you can find the following transforms:
More Data Services Integrator Transforms
These transforms are available in the Data Integrator branch of the Transforms tab in the Local Object Library:
|Allows a data flow to split its processing into two subdata flows and push down resource-consuming operations to the database server.
|Generates a column filled with date values based on the start and end dates and increment you specify.
|Generates an additional effective to column based on the primary key’s effective date.
|Flattens hierarchical data into relational tables so that it can participate in a star schema. Hierarchy flattening can be both vertical and horizontal.
|Map CDC Operation
|Sorts input data, maps output data, and resolves before and after versions for UPDATE rows. While commonly used to support Oracle or mainframe changed data capture, this transform supports any data stream if its input requirements are met.
|Rotates the values in specified columns to rows.
|Rotates the values in specified rows to columns.
|Processes large XML inputs in small batches.
Let's describe the use cases for some of them.