VOLATILE TABLE

CREATE MULTISET VOLATILE TABLE VTBL_01,

NO FALLBACK ,

CHECKSUM = DEFAULT,

NO LOG

AS(

SELECT * FROM ${_table_name2} WHERE nm_tran = 'GDN_C_ITEM_BALANCE'

) WITH DATA

PRIMARY INDEX

(dt_dat_cre ,cd_prod_div )

PARTITION BY RANGE_N(dt_dat_cre BETWEEN DATE '1950-01-01' AND DATE '2100-12-31' EACH INTERVAL '1' DAY );

ON COMMIT PRESERVE ROWS;

Tweet