Sample Header Ad - 728x90

Should the T and L phase of a well tuned ETL report process take the same amount of time regardless of the time bucket width and data size?

1 vote
3 answers
200 views
For an ETL reporting system, is it normal for the total execution time for a pull of 15 minutes with no data to be similar to a 24 hour pull with data? ------------- I had expected that the total time for ETL when there is NO data would be shorter but that is not the situation between a 15 minute and 24 hour pull. But I must confess that I know nothing about the internals of the T and L phases within a report server. Can someone shed light on whether the T and L phases are typically fixed in duration (up to a point)?
Asked by D-K (543 rep)
May 28, 2021, 05:51 PM
Last activity: Jul 19, 2021, 07:40 PM