 |
 |
Archives of the TeradataForum
Message Posted: Thu, 15 Jul 2004 @ 18:48:24 GMT
| 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.
| |
