LOGOFF − Ends all sessions and terminates FastLoad.HARDWARE SERVICES Hardware Support Lifecycleįor Teradata hardware platforms, Teradata will provide remedial maintenance services for six (6) years from its Platform Sales Discontinuation Date.
Distributes the records into the target table. INSERT − Inserts the records from the input file into the target table.ĮND LOADING − Initiates phase 2 of the FastLoad. SET RECORD − Specifies if the input file format is formatted, binary, text or unformatted.įILE − Specifies the input file name and path. LOGON − Logs into Teradata and initiates one or more sessions.īEGIN LOADING − Identifies the table to be loaded.ĮRRORFILES − Identifies the 2 error tables that needs to be created/updated.ĬHECKPOINT − Defines when to take checkpoint. **** 03:19:14 Application Phase statistics:įollowing is the list of common terms used in FastLoad script. Total Error Table 2 = 0 - Table has been dropped Total Error Table 1 = 0 - Table has been dropped In the log, you can see the number of records processed by FastLoad and status code.
Once the above command is executed, the FastLoad script will run and produce the log. Once the input file employee.txt is created and the FastLoad script is named as EmployeeLoad.fl, you can run the FastLoad script using the following command in UNIX and Windows. Locks on the target table is released and the error tables are dropped.Ĭreate a text file with the following records and name the file as employee.txt.įollowing is a sample FastLoad script to load the above file into Employee_Stg table. Phase 2 starts when FastLoad receives the END LOADING statement.Įach AMP sorts the records on row hash and writes them to the disk. Then AMPs hash each record and redistribute them to the correct AMP.Īt the end of Phase 1, each AMP has its rows but they are not in row hash sequence. The Parsing engines read the records from the input file and sends a block to each AMP. How FastLoad WorksįastLoad is executed in two phases. Target table should not have secondary index, join index and foreign key reference. It doesn't load duplicate rows even if the target table is a MULTISET table. Since it does not use transient journals, data can be loaded quickly. FastLoad utility is used to load data into empty tables.
0 kommentar(er)
