X hits on this document

385 views

0 shares

1 downloads

0 comments

126 / 131

Teradata

Knowledge Modules

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.

Type

Knowledge Module

Description

Check

CKM Teradata

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

Integrate

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

Integrate

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

126/131

Document info
Document views385
Page views388
Page last viewedWed Dec 07 17:18:24 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments