I'm new to working with a Teradata data source. Does anyone know the file extension for a Teradata Database?
Teradata uses it's own filesystem on raw devices -> no file, no extension
Teradata is a database like any other (only cooler, faster, etc) with a default port (1025) that you point your chosen connection mechanism at (JDBC for Java Apps, ODBC for C/C++, .Net Provider for C#).
If you are a Java Developer may I recommend The Friday Night Project series of articles (http://developer.teradata.com/applications/articles/the-friday-night-project). For other mechanisms for accessing Teradata go to the Connectivity and Tools headings.