|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/25/2006 6:33:00 AM
Posts: 4,
Visits: 1
|
|
I am new to Teradata and would appreciate, if someone could respond to following queries.
-Is there any documentation on the architechture of Teradata and how does it store the data/tables?
-Where can I find the TPT API/SDK and relevant documentation on HOWTO use it? Is it available for free download from NCS?
-Is TPT API supported in v2r5 version?
-Are there any samples of code which depicts the usage of TPT API to extract data from/load data into Teradata?
Thanks
PSPL
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 6/9/2008 2:55:55 PM
Posts: 185,
Visits: 2
|
|
You can find free documentation at www.info.ncr.com.
The TPT documentation is under "Teradata Tools and Utilities". If you go to "Teradata Tools and Utilities 8.1", you will find there is a manual on the TPT API.
To get somewhat familiar with Teradata, you can go to "Teradata Database" and go into "v2r6.1.1" (for the latest release). In there, there is a manual called "Introduction to Teradata Warehouse". There is a section on data distribution.
I don't believe that the TPT/API was introduced prior to the 8.1 release. Prior to 8.1, TPT was called Teradata Warehouse Builder, so you can find documentation on it for v2r5 (TTU 7.0 or 7.1) under that release.
I have not used the TPT/API (though I have used Teradata Warehouse Builder pretty extensively). It does look like the TPT/API manual does contain some code examples.
Good luck!
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/25/2006 6:33:00 AM
Posts: 4,
Visits: 1
|
|
Thank you Barry for your detaled reply. I will go thro' the docs.
I am trying to extract/load data from/to TD using these TPT APIs thro C++. so I am waiting for the v2r6 to get shipped soon. In the meantime, I have the v2r5 version, so can you pl guide me in making use of TWB API by sharing some code snippets?
Thanks.
Mataprasad
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/3/2006 2:30:00 AM
Posts: 20,
Visits: 1
|
|
Hi Let me know this is th eone you want fot your postings on forum
===================================================================
PCNVFESP utility converts FastExport scripts into TWB job
scripts that use the TWB Export operator and possibly:
DataConnector Operator
Access Modules (via the DataConnector
PCNVFEXP utility takes as its primary arguments:
The file containing the FastExport script and The file that will contain the resulting TWB job script
pcnvfexp -i FastExportScriptFileName -o TWBScriptFileName -b BteqJobFilename -d MessageFilename
Sushant Paricharak
SUSHANT P PARICHARAK Teradata Certified Professional
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/16/2009 6:55:04 PM
Posts: 3,
Visits: 4
|
|
|
The question that wasn't answered was - where do we get the TPT API (specifically x64). I've talked to teradata support who don't even know they make a 64-bit TPT API. I know it's out there, how do we get it?
|
|
|
|