Archives of the TeradataForum

Message Posted: Tue, 04 May 2010 @ 13:16:08 GMT

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

Hi Megan,

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!

Paul

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