Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Sep 2002 @ 12:01:14 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Teradata and AS/400
From:   Phil Oldfield

Iceland Foods which is where i work holds the majority of data loaded onto the Data Warehouse on AS/400's We do not use an etl tool but use RPG which is AS/400 programming language to extract and transform the operational data. Beware of internal AS/400 data formats (Dates and Packed Decimals) and signed numerics. This data is then ftp'd to a unix machine which is our staging server. This data is then loaded onto the Data Warehouse using the traditional fastload/multiload etc.

I can give you more detail if necessary

Phil Oldfield
Senior Technical Specialist
Iceland Foods

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