Archives of the TeradataForum
Message Posted: Tue, 15 Oct 2002 @ 12:56:22 GMT
| Subj: || || Re: Question Regarding Data Loading |
| From: || || Geoffrey Rommel |
| ||Assume that I have 6 columns and first 3 come from one file and 1 is coming from another file and rest of the 2 are coming from
another file. How can I import data from multiple sources to one table with different coming from different files?|| |
There is no "automatic" way to do this. The best way to handle this would be to FastLoad the three files separately and then join
them in Teradata. A less attractive possibility is to match the files together at the source and then load them.