Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 15 Jul 2004 @ 18:48:24 GMT


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


Subj:   Re: AS/400
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, July 15, 2004 14:23 -->

We are handling two cases using Pull Strategy. 1st is the load of history data of 3-5 years. This is done taking all data from AS400 application before turning the journaling on it. 2nd is daily/weekly load which are built using Journals in AS400 application. Daily the job is completed at source system and data is stored in a flat file. The files are pulled using ftp and stored in UNIX Server. The data is loaded in to Teradata using mload via Informatica. You may avoid loading to UNIX server via Informatica in case you do not want to perform any transformation and you don't have multiple sources of data. In that case you may load it to Teradata box, cron the mload jobs and be happy.

Thanks.



     
  <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