Jump to: navigation, search

ETL Section



  


DayChunk

Default Value: 7
Valid Values: Any integer between 1 and 31
Changes Take Effect: Immediately
Dependencies: Should be less than (DaysBack+ DaysAhead)

Specifies the number of days that will be processed at a time.

The tracked day range is defined by the values set in the DaysBack and DaysAhead parameters and is processed in the specified chunks of data. So, this parameter determines the size of transaction.

Larger transactions require more memory and other resources, but can be processed faster.

DaysAhead

Default Value: 14
Valid Values: Any integer between 1 and 365
Changes Take Effect: Immediately
Dependencies: None

Specifies the number of days (from current date) in the future to track Fact data.

DaysBack

Default Value: 14
Valid Values: Any integer between 0 and 365
Changes Take Effect: Immediately
Dependencies: None

Specifies the number of days (from the current date) in the past to track Fact data.

ETLTimeout

Default Value: 180
Valid Values: Any integer between 0 and 2880
Changes Take Effect: Immediately
Dependencies: None

Specifies the timeout interval (in minutes) between each execution of the Extract, Transform, and Load (ETL) process.

If you set this option to a negative or 0 value the ETL process is disabled.

Comment on this article:

blog comments powered by Disqus
This page was last modified on 13 July 2017, at 10:51.