Archives of the TeradataForum
Message Posted: Mon, 17 Jan 2000 @ 23:34:56 GMT
| Subj: | | Multi-type records in multiload |
| |
| From: | | Walt Craig |
We get a file containing one or more batches of transactions. The records are arranged with a header followed by several detail records
followed by a trailer record. There may be more than one batch in a given file, but the batches will always be preceded by a header and
followed by a trailer. We want to MLoad the headers and trailers into one table and the detail records into another. Once a batch is
loaded we will then update all the detail records with a batch identifier. It was assumed this operation would involved only ONE batch per
input file. Loading these records and updating the detail records after the load is easy. Now we need to load multiple batches from one
file. We can separate the batches into individual files but I would like to save that step and do this in MLoad. The host platform does
not support INMODS so that is not an option. Moving the data to the UNIX platform where an INMOD is an option adds another step. I was
trying to reduce the steps to one by using MLoad. Any ideas will be appreciated.
Thx
Walt Craig
Baseline Consulting Group
| 
