17th September, 2018
Step1: To work with TPT Java Run time should be install[JDK-6025 Java ER] There are 2 ways to work TPT
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
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 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 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
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
Write For Us