Burst Example 2: TimeTable, SplitCriteria ('proportional') - Teradata Vantage

Input

• input_table: burst_example from Burst Example 1: TimeInterval, SplitCriteria ('nosplit')

SQL Call

SELECT * FROM Burst (
  ON burst_example AS input_table PARTITION BY id ORDER BY id
  USING
  TimeColumn ('start_time_column', 'end_time_column')
  TimeInterval (86400)
  TargetColumns ('num_custs')
  StartTime ('08/01/2010')
  EndTime ('08/10/2010')
  SplitCriteria ('proportional')
  Accumulate ('id')
) AS dt ORDER BY id;

Output

The value assigned to each subinterval is determined by dividing the value from each row by the number of subintervals in the row. For example, the value assigned to 2010-08-06 is based on the first 3 rows of the input table: 400/5 + 500/6 + 200/4 = 80 + 83.33 + 50 = 213.33