may i know on which pdf i can find the table descriptions, there data about the tables used in the pdf. i.e CUSTOMER,OFFERINGS,ENROLLMENT, COURSES...etc. so that i can work on the examples provided in pdfs. do i need to run any script for that to create tables and to insert data into it.
like demobld.sql file of ORACLE is there any script available in Teradata. demobld.sql file contains all the tables like EMP,DEPT,JOBS,SALGRADE Tables structure and the rows for these tables. so i am expecting the same kind of script or a pdf which contains structure and its inserting rows or the name of teradata pdf which contains these information.
Hi dixon, there's a script in C:\Program Files\NCR\Tdat\LTDBMS\etc\perddl.bteq, but the sample db is quite small. It's described in the manuals: Basic Teradata Query Reference APPENDIX B Loading and Using the Sample Personnel Database
Another option is to modify the Oracle script to Teradata-SQL. Then you could compare Teradata/Oracle SQL. I did something similar once with Microsoft's pubs database.