Archives of the TeradataForum
Message Posted: Thu, 22 Jul 2004 @ 16:42:06 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|