Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 28 Feb 2007 @ 21:14:14 GMT


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


Subj:   Multiple record types using mload
 
From:   Kopuuravuri, Ramu

How to load the data with multiple record types using mload or fastload?

i.e I have multiple records with different no of columns

     row 1 : 3 columns
     row 2 to 10 : 4 columns
     row 3 : 2 columns

Hear ineed to load the data into 3 tables like tab_a,tab_b and tab_c

I'm trying to create .LAYOUT like

     .FILLER Indicator 1 Datatype
     .FIELD  F_name * Datatype_tab_a_col_1
     .FIELD  F_name * Datatype_tab_a_col_2
     .FIELD  F_name * Datatype_tab_a_col_3

     .FIELD  F_name * Datatype_tab_b_col_1
     .FIELD  F_name * Datatype_tab_b_col_2
     .FIELD  F_name * Datatype_tab_b_col_3
     .FIELD  F_name * Datatype_tab_b_col_4

     .FIELD  F_name * Datatype_tab_c_col_1
     .FIELD  F_name * Datatype_tab_c_col_2
     .FIELD  F_name * Datatype_tab_c_col_3

And I have '|' delimited file

Sample File data

     A|aa|aaa
     B|aaa|aaaaa|aaaa|aaa
     B|bbb|bbbbb|bbbb|bbb
     C|aaaaa|aa|aaa
     C|bbbbb|bb|bbb

Based on A,B and C I need to load into tab_a,tab_b and tab_c

In .import mode I try to give FORMAT as '|' with VARTEXT and multiple APPLY conditions. i.e APPLY lable_dml where Indicator= 'A' etc..

I'm facing the error like

"Not enough fields in vartext data record number: 1"


hear in first row has only 3 columns... so no of fields is not sufficient for .LAYOUT ... so how to FILLER the records based on the A,B and C?

Can u please help me out how to provide a solution for this issue?


Thanks in Advance,

Ramu.



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016