C.4 ETL Job Failure

When you run the ETL jobs, the transaction logs are being generated, which keeps on increasing in size in every ETL cycle leading to ETL jobs failure.

To restrict these logs from being generated and prevent the failure of the ETL jobs, you need to execute the following query in the SQL Server Query Analyzer against the corresponding Data Mart database:

EXEC dbo.SetsValue 'RestrictTransactionLog','TRUE',1

For more information on restricting the transaction logs, see Section 8.5, Restricting the ETL Transaction Logs.