Archives of the TeradataForum
Message Posted: Fri, 16 Nov 2002 @ 00:11:34 GMT
| Subj: || || Loading a table from another table |
| From: || || Ahnell, Dave |
I need to load a table from another table's data. I was planning on using Fast Export to export the data to a file and then use FastLoad
to load the export file to the new table.
Anyone have an example FastLoad script that would load a Fast Export export file? I'm having trouble figuring out how the SET RECORD,
DEFINE, and other parameters should be defined for this.
Also should the MODE parm on the Fast Export script be set to INDICATOR or RECORD to accomplish this?