Create button in the main menu and select the object type on the New Object side panel.A log is used to store ETL task execution information. In fact, a log is a table with predefined list of fields. The number of log fields is fixed but one can also add new fields.
Information about 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.
To create a log in the object navigator click the Create button in the main menu and select the object type on the New Object side panel.
After executing the operations the log creation wizard opens:
Determine settings on the pages:
Basic Settings/Basic Properties. The page is used to set object name, identifier and comment.
Properties. The page is used to specify the database where the log must be created as well as physical name of the table, which must correspond to the repository log.
Fields. The page is used to create a list of additional log fields.
The created log table includes the fields:
Date (STAMP). Date and time of a certain operation execution.
User (USER_ID). User name.
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 created on the Fields page of the wizard.
To save settings in the log wizard:
Click the Save button.
Select the Save and Close item in the drop-down menu of the Save button. After this the specified settings are saved, the wizard closes, and the data edit mode opens.
NOTE. The Save and Close item is available only on editing the settings.
To link a log to an ETL task, execute the following operations:
Create a log.
Open the ETL task object, to which the log is linked.
Select the Task > Properties item in the ETL task's main menu, after which the ETL task wizard opens.
Select the created log on the Task Settings wizard page.
See also:
Creating Table Data Sets | ILog
Edit settings
Settings button in the main menu.