09 November 2010

Teradata Basics Te0-121 - Refined objectives from Developer Forum

Hi all,

I was confused to see the objectives listed in the Teradata preperation site, But found that the objectives at the following link is a good place to kick start preparing for Teradata certifications.

The below is an extract from the following link
http://developer.teradata.com/database/training/introduction-to-the-teradata-database

Teradata Basics - TE0-121


Topics

  • The purpose of the Teradata Database
  • Definition of terms (such as Table, Column, Row, Domain, Primary Key and Foreign Key) associated with Relational Databases
  • Differences between the Data Warehouse and the different types of Data Marts
  • The five stages of Data Warehouse evolution
  • Architecture and components (such as Node, VPROC, PE, BYNET and AMP) of the Teradata Database and how the Teradata Database uses parallelism to achieve its high performance
  • The types of Database Objects (such as Database, User, Table, View and Macro) that may be defined in the Teradata Database
  • The purpose of the tools (such as BTEQ, SQL Assistant, FastLoad, Teradata Manager and Teradata Dynamic Workload Manager) available to support the Teradata Database
  • The purpose of Permanent Space, Temporary Space and Spool Space in the Teradata Database
  • How the Teradata Database uses the Primary Index of a table to distribute and store the rows of a table
  • How the Teradata Database uses the optional Secondary Index of a table to improve data access performance
  • Methods of data protection and types of fault tolerance built into the Teradata Database (such as Clique, Cluster, Fallback Table, Transient Journal and Permanent Journal)

24 October 2010

Teradata SQL assistant JAVA edition - Like excel for data manipulation

Hi,

Iam basically a Oracle developer since I currently switched to Teradata, I was given "Teradata sql assistant" to work.

In my work m, I need to load  and manipulate a large amount of data,but I found that SQL assitant did not help me much.While I was browsing through the teradata forums found this tool, "Teradata sql assistant - JAVA edition".

The tool aided me in browsing all the database objects very easily and manipulate the data with ease.

Creating Database objects





Manipulating data objects (Doing a insert or update)








Teradata sql assistant - JAVA edition is the best tool for the developers or QA to have a quick view of data, manipulating data like a spreadsheet.

Find the following link to have more detailed information about Teradata sql assistant - JAVA edition.

Teradata SQl assistant - JAVA edition

regards
Kaushik

Note -
I have shared my view based on a article available in teradata forums and the views expressed above is purely mine.