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?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.