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

1. Through wizard
2. By writing script to execute like FL, ML Name: Script

Ex: 1^st 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   2^nd 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