Archives of the TeradataForum
Message Posted: Tue, 08 Jan 2002 @ 17:13:47 GMT
| Subj: || || Re: How to use Informatica and Teradata support tools for DW |
| From: || || Dave Ahnell |
Just use your ETL tools to do the extraction and cleansing and have them generate load-ready flat files in a load staging area. Then use
FastLoad and/or Multiload to load these files to the database. You're right the Teradata load utilities will handle this much faster.
You can use an enterprise scheduling tool like AutoSys to pull all of this together so that the database load processes are tied to the
completion of the ETL processes as well.