Log is used to store the information on ETL tasks execution. In fact, a log is a table with predefined list of fields. The number of fields is fixed, but there is also a possibility to add new fields.
Information on the following operations is saved to log:
Recording the start of ETL task execution.
ETL task execution error.
Skip records.
Add records.
Recording the completion of ETL task execution.
Log creation wizard is used to create a log:
In object navigator, select:
The Create > Other > Log context menu item.
The New Object > Other > Log item in the Create group on the Home ribbon tab.
In the opened ETL task:
Select the Task > Properties main menu item.
In the opened wizard go to the Task Options page.
Click the Create button.
A log creation wizard opens after executing one of the operations:
Determine settings on the pages:
Properties. Specifies the database where the log must be created as well as physical name of the table, which must correspond to the repository log.
Fields. Forms the list of additional log fields.
NOTE. It is available to create and process logs only in the desktop application.
A log table consists of the following fields:
Date (STAMP). Date and time of a certain operation execution.
User (USER_ID). Username.
Operation (OP). Names of executed operations.
Success (OP_SUCC). Operation result (0 if the operation failed or 1 if the operation is successfully completed).
Object Identifier (OBJ_ID). ETL task object identifier.
Object Name (OBJ_NAME). ETL task object name.
Description (DESCR). Description of executed operation.
All user fields determined on the Fields page of the wizard.
To view data, select the corresponding object in the object navigator and execute one of the operations:
Double-click with the main mouse button.
Select the Open context menu item.
Select the View item on the Home ribbon tab.
A dialog box with data opens. Description of this dialog box and principles of working are described in the Working with Data Set section.
To link a log to an ETL task, execute the following operations:
Use the log creation wizard to create a new log.
Open the ETL tasks object to which the log is linked.
Select the Task > Properties item in the main menu of the ETL task after which the ETL task editing wizard will be displayed.
Select the created log on the Task Options wizard page.
See also:
Creating Table Data Sets | ILog