Data Integrator Transform Samples
The attached zip file contains the exported Data Integrator jobs (.atl file), a SQL script to create the necessary source and target tables and a readme.txt with additional installation instructions. The transforms covered in this tutorial are : Case, Effective_Date, Hierarchy_Flattening, Pivot, Reverse_Pivot, Validation and Slowly Changing Dimension transforms (Table_Comparison, History_Preserving, Key_Generation). An additional sample is included to show the ability to call external web services (this needs the web services adapter to be configured). These samples will work with Data Integrator 11.5 and above (including 11.7.x)
