![]() ![]() Two main script sections DEFINE JOB File_Load DESCRIPTION ‘Load table from flat file’ ( DEFINE SCHEMA Customer_Accounts Account_Number INTEGER, Account_Name VARCHAR(50), Trans_Number INTEGER, Trans_Date ANSIDATE, Trans_Amount VARCHAR(20) ) DEFINE OPERATOR File_Reader TYPE DATACONNECTOR PRODUCER SCHEMA Customer_Accounts ATTRIBUTES VARCHAR FileName VARCHAR Format VARCHAR OpenMode VARCHAR TextDelimiter VARCHAR PrivateLogName /* continued on next page */ Declarative Section Defines the “what”: DEFINE SCHEMA object(s) DEFINE OPERATOR object(s)ĥ Job Script Example Before Simplified Syntax (continued) Teradata Parallel Transporter and 14.0 introduces a simplified script syntax: Smaller and simpler job scripts Less job script maintenance with use of operator templates User-defined templates allow any degree of customization Generated schema objects Generated SQL insert statement Standardized the names of job variables that correspond to operator attributes Target audience of this presentation: Users of script-based TPT Users who write TPT job scripts Users who work with TPT job script generation toolsĤ Job Script Example Before Simplified Syntax Job Script Example Before Simplified Syntax Using Operator Templates Using Generated Schemas Using Generated SQL INSERT Statements Job Script Example After Simplified Syntax Q & Aģ Introduction Customer ease-of-use is of paramount importance to Teradata’s strategy. Nam Tran, Teradata Parallel Transporter Teradata Corporation October 6, 2011 1 Teradata Parallel Transporter Scripts with Simplified Syntax ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |