Refer to section Generic SQL for additional Knowledge Modules that work with this database.
The Oracle Data Integrator KMs include specific optimizations for Teradata. These optimizations and their configuration are detailed in the KM Optimizations for Teradata section.
Checks data integrity against constraints defined on a Teradata table. Rejects invalid records in the error table created dynamically. Can be used for static controls as well as flow controls.
Consider using this KM if you plan to check data integrity on a Teradata database.
This KM support the following Teradata optimizations: Primary Indexes and Statistics
IKM File to Teradata (TTU)
This IKM is designed to leverage the power of the Teradata utilities for loading files directly to the target. It is restricted to one file as source and one Teradata table as target.
Depending on the utility you choose, you'll have the ability to integrate the data in either replace or incremental update mode.
Consider using this IKM if you plan to load a single flat file to your target table. Because it uses the Teradata utilities, this IKM is recommended for very large volumes.
To use this IKM, you have to set the staging area to the source file's schema.
This KM support the following Teradata optimizations: Primary Indexes and Statistics Support for Teradata Utilities Optimized Temporary Tables Management
IKM SQL to Teradata (TTU)
Integrates data from a SQL compliant database to a Teradata database target table using Teradata Utilities.
This IKM is designed to leverage the power of the Teradata utilities for loading source data directly to the target. It can only be used when all source tables belong to the same data server and when this data server is used as a staging area (staging area on source). Source data can be unloaded into a file or Named Pipe and then loaded by the selected Teradata utility directly in the target table. Using
Knowledge Modules Reference Guide