7.8.6.2 Transform Data (Data Transformation or DT Logs)
The logs for this type of task are created in the path as follows.
The following types of definitions can be defined under data transformations:
- Executing a Stored procedure
- Executing a Shell script
The following log files are created for the Stored Procedure execution type of Transform data. The definition name is available in these log files.
<FIC_HOME>/ficdb/log/date/DT_KYC12DOM_1221824179931_20121123_1_Task23.log
<FIC_HOME>/ficdb/log/date/RunProc_KYC12DOM_1221824179931_20121123_1_Task23.log
/ftpshare/<DT_Definition_name>.log/
The following logs are created for the Shell script type of Transform data:
<FIC_HOME>/ficdb/log/date/DT_KYC12DOM_1221824179931_20121123_1_Task23.log
Information related to the failure is inserted into the am_log_file which is available in the path:
<FIC_HOME>/ficdb/log/
Table 7-5 Shell Script Transform Data
| Component | Description |
|---|---|
| DT | This is a product indication for the Data transformation type of log. |
| RunProc | This indicated that the log is for running a procedure (function). |
| KYC12DOM | This is the INFODOM on which the batch was executed. |
| 1263964041287 | This is the ID of the RUN (batch is created once the RUN is saved). |
| 20121120 | This is the date on which the Batch was executed. |
| 2 | The batch is executed for the second time on the same day. |
| Task23 | This log file is for the Task23 of the batch. |
| DT_Definition_name | A log file is created with the name of the DT definition created. |