Archives of the TeradataForum
Message Posted: Mon, 29 Mar 2004 @ 15:48:17 GMT
| Subj: || || Re: Teradata Peformance issues when loading data to Teradata using ETL tools like Informatica or Data Stage |
| From: || || Paul Bralkowski |
We are in the process of building a warehouse with Informatica and started out with relational inserts to the tables. Since the responce is not
good due to journal inserts we moved to Tpump inserts. This does do a good job except when the primary index is not unique. Check your utilities
manual for Tpump also see Anita Richards document on Cross Comparison of Data Load Strategies.