 |
 |
Archives of the TeradataForum
Message Posted: Tue, 21 Jun 2011 @ 08:29:45 GMT
| Subj: | | Re: Mload Layout consideration |
| |
| From: | | Dieter Noeth |
Johnpaul Jepamony wrote:
| | In the MLOAD, the work table( WT) tables holds the intermediate data of processing and then loads the data into the permanent table. Here
in this case, does the WT table holds all the data of the 200 fields or only the 3 fields of the insert query. | |
Only FIELD data is sent to the work table, so just define the remaining 197 fields as FILLERs.
Dieter
| |
