The ETL job is the process by which data is extracted from an AppManager repository, transformed to a format appropriate to the Data Warehouse, and then loaded into the Data Warehouse.
When you run ETL jobs, the transaction logs are being generated and keep on increasing in size in each ETL cycle, which might lead to the ETL jobs failure.
To prevent this failure, you can restrict the logs from being generated by executing the following query in the SQL Server Query Analyzer against the corresponding Data Mart database:
EXEC dbo.SetsValue 'RestrictTransactionLog','TRUE',1
If you want to remove the above restriction on the ETL transaction logs, execute the following query:
EXEC dbo.SetsValue 'RestrictTransactionLog','FALSE',1