Tera data parallel Transpecter[TPT]
Tera data parallel Transpecter[TPT]
Step1:
To work with TPT Java Run time should be install[JDK-6025 Java ER]
There are 2 ways to work TPT
- Through wizard
- By writing script to execute like FL, ML Name: Script
Ex: 1st way
Wizard approach
To load the data from vinayaka database emp Table to vinay- USK emp empty table following the below steps
Start
↓
Right click
↓
New
Job Name: Vinayaka- vinay-emp-load
Next
Source type: Tera data Table
Tera data source:127.0.0.1
User name: Vinayaka
Pass work: vinay
Check include user ID in Generate Job
Check include password in Generate Job
Go to left hand side displayed data bases
Vinayaka Select emp
Select Right side emp columnsClick select all
Next
Select
Target type: Tera data table
Tera data host:127.0.0.1
User name: Vinayaka
Pass word: Vinay
Check include user ID in Generate Job
Check include password in Generate Job
Go to left hand side displayed data bases
Vinay- useSelect emp
Select load operator
Select Automatic mapping
Next
↓
Finish
Job name: Test- job
Commit interval:10000
New the Job runs, read the log message and observe the expected resultClick
Note - To see the script Generated, GO To Job script and see
2nd way
Coding
Define Job vinayaka- vinaya-load-job
(
Define operator w-1-0-vinayaka-vinay-load-job
Type load
Schema*
Attributes
(
Varchar User name,
Varchar Password,
Varchar Log table,
Varchar Target Table
Varchar Td pid
);
Define schema w-o-s-Vinayaka –vinay—load- job
( eid int,
Ename varchar(30),
Mgrid int,
Deptid int,
);
Define operator w-o-c-Vinayaka –vinay—load- job
Type export
Schema w-o-s-Vinayaka –vinay—load- job
Attributes
(
Varchar User name,
Varchar user Password,
Varchar Select stmt,
Varchar Td pid
);
Apply
(
Insert into vinay –usr.emp(eid, ename, mgrid, deptid) values(:eid,: ename, :mgrid, :deptid);
To operator
(
W-1-0- Vinayaka-vinay-load-Job[1]
Attributes
(
User name=’vinay -usr’,
User password=’vinay’;
Log table=’vinay’-usr. emp-Log’,
Target table=’vinay’-usr. Emp’,
Tdpid=’127.0.01’
)
)
Select * from operator
(w-o-o-Vinayaka –vinay—load- job[1]
Attributes
(
User name=’vinayaka’,
User password=’vinay’,
Sele CL Stmt=’Select eid,ename, mgrid, deptid from vinayaka .emp;’,
Tdpix=’127.0.0.1’
);
Execution - Log file navigation c:\program files\Tera data\client\13.0\Tera data parallel transporter\logs
StartRuncmd
TBUILD – F C:\TPT\TPT-Sample.txt
TPT[Tera data parallel Transporter]
Fast load: File Table
Mload: File Table
Tpump: File Table
Fast Export: Table File
BTEQ: File Table
TableFile Any operator in tera data
Table File
TPT IS A Multi function product for loading, Retrieving, processing and transforming data with in the tera data base and between external data base and the tera data data base
