Archives of the TeradataForum
Message Posted: Tue, 04 May 2010 @ 13:16:08 GMT
If the records are fixed length, and all the records are formatted the same, you should be able to accomplish this by defining multiple record layouts within the MLoad. You would have to define the record layout and insert statements for each combination or record/table.
So, basically you would assign a field in each "record type" to be used as the indicator for loading that set of data into a particular table. Your Apply statement would act as the "traffic cop" to direct the loading of tables based on the value of the indicator field you use.
Your APPLY statement may look something like this (modified to fit your needs):
.IMPORT INFILE FILEIN LAYOUT EXTRACT_FILE APPLY LOAD_TBL1 WHERE FIELD_ID = 'xxxx' APPLY LOAD_TBL2 WHERE FIELD_ID = 'yyyy' APPLY LOAD_TBL3 WHERE FIELD_ID = 'zzzz';
Hope this helps!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|