Archives of the TeradataForum

Message Posted: Thu, 22 Jul 2004 @ 16:42:06 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: MLOAD of a file with multiple record types

From:		Nomula, Madhukar

The file is pipe delimited.

The file format is:

     |3001|something|something|1234|456|
     |3002|gerbage|abcjndsf;sd|sldfjsd|ldfjsdklgf|sjdfsdkgvsd;|
     |3003|dfsfndsfn|dsfnsdln|
     |3004|sd;f;ds|
     |3005|zsdfgnsd;fj|lsdmfn|sdlmfnsd;nf|lsdzfnds;|lsdncs;dfn|sdfnds;fn|zsdn;dsnf|

The file i have has the record type format shown above. I needed to read that file into 5 layouts depending on the first field. Then load it into 5 tables. I just seperated the file into 5 files and loaded it but since the file is 7 gigabyes, it's taking lot of space.

Is there any way to load it using multiload.

Madhukar.