Teradata PX
Moderators: chulett, rschirm, roy
Teradata PX
Hi All,
I am loading data to Teradata from a dataset. My source has around 6 million rows and I have 6 fields.
The jobs takes around 5 hours to complete. Is there any way to make it faster. And my table is a full refresh.
Please Advice.
Thanks & Regards,
Kumar66
I am loading data to Teradata from a dataset. My source has around 6 million rows and I have 6 fields.
The jobs takes around 5 hours to complete. Is there any way to make it faster. And my table is a full refresh.
Please Advice.
Thanks & Regards,
Kumar66
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia
are you doing anything else in your job, then just reading the dataset and load using teradata Enterprise stage?
it should not take more then 10 min to load this volume.
the atrget is set table or multiset? have you choosen correct key and Primary Index.
for lnsert Teradata Enterprise stage is fastest.
it should not take more then 10 min to load this volume.
the atrget is set table or multiset? have you choosen correct key and Primary Index.
for lnsert Teradata Enterprise stage is fastest.
Hi Keshav,
It is a multiset table. I have pasted my DDL below:
CREATE MULTISET TABLE FFRED.STG_PMOTN,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
FREESPACE = 0 PERCENT,
CHECKSUM = DEFAULT
(
PMOTN_CD VARCHAR(20) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
PMOTN_ID INTEGER NOT NULL,
BI_INTF_PROC_NM CHAR(30) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
BI_INTF_CRT_DTTM TIMESTAMP(0) NOT NULL,
BI_ETL_BTCH_ID INTEGER NOT NULL,
BI_ETL_PROC_DTTM TIMESTAMP(0) NOT NULL)
UNIQUE PRIMARY INDEX ( PMOTN_CD ,PMOTN_ID );
Is there anything to add to the DDL?
Please Advise.
Thank & Regards,
Kumar66
It is a multiset table. I have pasted my DDL below:
CREATE MULTISET TABLE FFRED.STG_PMOTN,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
FREESPACE = 0 PERCENT,
CHECKSUM = DEFAULT
(
PMOTN_CD VARCHAR(20) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
PMOTN_ID INTEGER NOT NULL,
BI_INTF_PROC_NM CHAR(30) CHARACTER SET LATIN CASESPECIFIC NOT NULL,
BI_INTF_CRT_DTTM TIMESTAMP(0) NOT NULL,
BI_ETL_BTCH_ID INTEGER NOT NULL,
BI_ETL_PROC_DTTM TIMESTAMP(0) NOT NULL)
UNIQUE PRIMARY INDEX ( PMOTN_CD ,PMOTN_ID );
Is there anything to add to the DDL?
Please Advise.
Thank & Regards,
Kumar66
-
- Charter Member
- Posts: 47
- Joined: Fri Mar 18, 2005 5:59 am
Hi All,
I checked the log file and it gives me teradata error code 6750- Invalid Timestamp.
Then I changed TIMESTAMP(0) NOT NULL to CHAR(19) NOT NULL in my DDL.
The job takes 5 mins to complete the 6 million rows. Is it right to chnage the timestamo datatype to char? And
How to define the TIMESTAMP datatype in Teradata?
Please Advise.
Thanks & Regards,
Kumar66
I checked the log file and it gives me teradata error code 6750- Invalid Timestamp.
Then I changed TIMESTAMP(0) NOT NULL to CHAR(19) NOT NULL in my DDL.
The job takes 5 mins to complete the 6 million rows. Is it right to chnage the timestamo datatype to char? And
How to define the TIMESTAMP datatype in Teradata?
Please Advise.
Thanks & Regards,
Kumar66