Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 May 2003 @ 15:21:20 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Options for Oracle to Teradata
From:   Dwight Etheridge

Look into CA Fastunload for Oracle.

It pulls data blocks directly, bypassing the Oracle DBMS. It has lots of neat switches, and accepts control files. Control files may contain SQL. SQL can specify columns and 'where' clauses. It supports fixed-lrecl output, or csv output. When output is fixed, it emits a record layout to match what it emitted. When output is csv, it puts out a create table to match.

It can write to pipes or files. With a little effort, you could hookup Fastload or Multiload to read on the pipe or file.

Dwight Etheridge
Teradata Certified Master

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016