Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 20:51:47 GMT

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

Subj:   Re: Loading Fact data directly onto Teradata
From:   Anomy Anom

<-- Anonymously Posted: Thursday, December 05, 2002 15:26 -->

Hi Frank,

I have a question on the Informatica usage for data loading. What is the volume of data loaded by Informatica from Source systems in one load and in what time?

We have AS/400 system from where the transaction data is passed on to the Warehouse. Since transferring data from AS400 to Oracle over ODBC is very slow, we create flat file extracts on AS400 system and ftp over to Unix for loading into Oracle by SQL*LOADER.

We also did some tests using Informatica to load data from AS400 tables to Oracle and proved to be more than 10 times slower compared to the ftp/sqlloader process.

How do you load your data from Legacy systems to Teradata through Informatica?

Another question is that where is Informatica server installed? Can we install Informatica on MP-RAS or does it require a Sun-Solaris Unix?


  <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: 28 Jun 2020