I am new to teradata.
There are two tables as below:
CREATE MULTISET TABLE ACCOUNT_FACT ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
ACC_KEY DECIMAL(18,0) TITLE 'Arrangement Key' NOT NULL,
SOME_DATA VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC
YEAR_MONTH INTEGER TITLE 'Period Key' NOT NULL,
PROCES_DATE DATE FORMAT 'YYYY-MM-DD' TITLE 'Processing Date',
PRIMARY INDEX PMY_IDX ( ACC_KEY )
PARTITION BY RANGE_N(YEAR_MONTH BETWEEN 200801 AND 200812 EACH 1 ,
200901 AND 200912 EACH 1 ,
201001 AND 201012 EACH 1 ,
201101 AND 201112 EACH 1 ,
201201 AND 201212 EACH 1 ,
CREATE SET TABLE TABLE_A ,NO FALLBACK ,
SOURCE_ID CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'Account Application System Identifier'
UNIQUE PRIMARY INDEX PMY_IDX ( ACC_KEY)
Note: While loading ACCOUNT_FACT YEAR_MONTH field is extracted from PROCES_DATE field
SELECT A.ACC_KEY, SOME_DATA FROM
It is taking more time to load, is it possible to tune this?