X hits on this document

379 views

0 shares

1 downloads

0 comments

40 / 131

Load

Load

Reverse- Engineer

target. It should be set to a Netezza location.

LKM File to Netezza (EXTERNAL TABLE)

Loads data from a File to a Netezza Server staging area database using the EXTERNAL TABLE feature (dataobject).

Because this method uses the native EXTERNAL TABLE command, it is more efficient than the standard “LKM File to SQL” when dealing with large volumes of data. However, the loaded file must be accessible from the Netezza server machine.

Consider using this LKM if your source is a large flat file and your staging area is a Netezza server.

LKM File to Netezza (NZLOAD)

Loads data from a File to a Netezza Server staging area database using the native NZLoad utility.

The nzload commmand is a wrapper to the nzsql CREATE EXTERNAL TABLE/INSERT INTO commands. It allows you to load data from the local host or a remote client.

Consider using this LKM if you want to manipulate the data prior to loading it.

RKM Netezza (JYTHON)

Retrieves JDBC metadata from a Netezza database. This RKM may be used to specify your own strategy to convert Netezza JDBC metadata into Oracle Data Integrator metadata.

Consider using this RKM if you encounter problems with the standard JDBC reverse-engineering process due to some specificities of the Netezza JDBC driver.

Knowledge Modules Reference Guide

40/131

Document info
Document views379
Page views382
Page last viewedWed Dec 07 00:11:08 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments