Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 13 Oct 2003 @ 22:41:11 GMT


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


Subj:   Re: Teradata and Informatica
 
From:   Jim Downey

Chan,

The problem with Informatica and any tool is that you are inserting a process in the middle. In general, you are reading from one platform, thru the Informatica server to the target platform. That is two trips across the network and 3 platforms involved.

We have an Oracle datamart that we feed from Teradata. We have Fastexport loaded on the same platform as the oracle datamart. We execute FastExport which pulls data from Teradata and writes it to a pipe which is read by Oracle's SQL Loader... the data goes from database to database and never lands on the file system

When using Informatica, make sure it is using the best utility for the job. There is a sweet spot where it is better to use BTEQ to extract small numbers of rows and the bulk utilities for larger numbers.

Jim



     
  <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: 15 Jun 2023