Tags » Teradata

Connection Profile Using Teradata Studio

  • Open Tedadata Studio Express
  • Create new Data Connection

  • Select Teradata Database, Enter Name and Press <Next>

  • Enter Required information and Test connection
  • Database server name: TD-EXPRESS…
  • 25 more words
SharePoint 2010

TD Tips

Show OBJECT_NAME:- Displays ddl for OBJECT_NAME

Show <Select… from table1,table2,table2 where …> will give ddls for all tables involved in the select statement

HELP STATISTICS:- To display stat details

Td

TD PT Tips

Some reasons for performance issues on Teradata

  1. Out of spool error
  2. Skew data
  3. Old stats
  4. Bad PI selection
  5. Product joins-Missing joins
  6. Duplicating a large table on all amps…
  7. 100 more words
Performance Tuning

Teradata ARCMAIN

LOGON IP/userid,pwd;
ARCHIVE DATA TABLES
(DB.customer),
(DB.customer_Account),
(DB.glf), RELEASE LOCK, FILE = ARC_TBLE;

LOGON IP/username,pswd;
COPY DATA TABLES
(DD_STG.customer) (FROM(DB.customer)) ,
(DD_STG.customer_Account) (FROM(DB.customer_Account)),
(DD_STG.glf) (FROM(DB.glf)) 122 more words

Business Intelligence

TE0-141 Practice Test - Teradata

Embarking on the Career of Your Dream

Being a certified professional is a matter of procedure in today’s world. The first step is to knowing the career of your dreams; the second is to embark on a certification exam that will help achieve your goals by verifying that you are well-versed in your field. 806 more words

TE0-141

Teradata TE0-01A Exam Questions

Embarking on the Career of Your Dream

Being a certified professional is a matter of procedure in today’s world. The first step is to knowing the career of your dreams; the second is to embark on a certification exam that will help achieve your goals by verifying that you are well-versed in your field. 833 more words

TE0-01A

Christmas Party 12/04/2015

My first Christmas Party with Teradata.

It was Mafia-themed event turning formal. Haha. From the venue at Casa Real in Acacia Estates, the food catering service, minibar drinks service, photobooth, organized formal programs, games, raffles, ambiance, i think it’s the best Corporate-TEAM Christmas Party I ever attended. 10 more words