 |
 |
Archives of the TeradataForum
Message Posted: Tue, 04 May 2010 @ 09:17:00 GMT
| Subj: | | Re: MLoad - Fixed Length Record |
| |
| From: | | Howard Bradley |
| | Is there an easy way to load a flat file that has fixed length record, but has multiple records on each row? | |
Hi Megan
I don't think there is an "easy" way, but if you don't want to write an INMOD or to pre process the file in any way and are restricted to a
Teradata utilities solution you could load the data to a large enough CHAR column (if the number of records is known in advance) or VARCHAR column
and then use a recursive query to strip out the records to be stored individually as rows on a second table.
Painful, but should work OK with a reasonable number of records :-)
Cheers
Howard
| |
