When the POSITION parameter is not used, multiple INTO TABLE clauses
process different parts of the same (delimited data) input record, allowing
multiple tables to be loaded from one record. When the POSITION parameter is used,
multiple INTO TABLE clauses can process the same record in different ways,
allowing multiple formats to be recognized in one input file
POSITION is needed to reset the pointer to the beginning of the record
again. In delimited formats, use "POSITION(1)" after the first column
to reset the pointer.
OPTIONS (SKIP=1,READSIZE=1000000, BINDSIZE=1000000, ROWS=200,ERRORS=200000 )
LOAD DATA
INFILE '$1'
TRUNCATE
INTO TABLE geps_price_list_stg
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(
Price_List_Name "TRIM(:Price_List_Name)",
Product_Context "TRIM(:Product_Context)",
Product_Attribute "TRIM(:Product_Attribute)",
Product_value "TRIM(:Product_value)",
Product_Description "TRIM(:Product_Description)",
UOM "TRIM(:UOM)",
Primary_UOM "TRIM(:Primary_UOM)",
Line_Type "TRIM(:Line_Type)",
price_break_type "TRIM(:price_break_type)",
Application_Method "TRIM(:Application_Method)",
Value_uom "TRIM(ROUND(:VALUE_UOM, 2))",
Dynamic_Formula "TRIM(:Dynamic_Formula)",
Static_Formula "TRIM(:Static_Formula)",
Start_Date "TRIM(:Start_Date)",
End_Date "TRIM(:End_Date)",
Precedence "TRIM(:Precedence)",
process_flag "TRIM(:process_flag)",
TRANSACTION_TYPE "TRIM(:TRANSACTION_TYPE)"
)
INTO TABLE geps_price_list_stg_sss
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(
Price_List_Name POSITION(1) "TRIM(:Price_List_Name)",
Product_Context "TRIM(:Product_Context)",
Product_Attribute "TRIM(:Product_Attribute)",
Product_value "TRIM(:Product_value)",
Product_Description "TRIM(:Product_Description)",
UOM "TRIM(:UOM)",
Primary_UOM "TRIM(:Primary_UOM)",
Line_Type "TRIM(:Line_Type)",
price_break_type "TRIM(:price_break_type)",
Application_Method "TRIM(:Application_Method)",
Value_uom "TRIM(ROUND(:VALUE_UOM, 2))",
Dynamic_Formula "TRIM(:Dynamic_Formula)",
Static_Formula "TRIM(:Static_Formula)",
Start_Date "TRIM(:Start_Date)",
End_Date "TRIM(:End_Date)",
Precedence "TRIM(:Precedence)",
process_flag "TRIM(:process_flag)",
TRANSACTION_TYPE "TRIM(:TRANSACTION_TYPE)"
)
No comments:
Post a Comment