Burst Example 4: Time_Table File - Teradata Vantage

Input

SQL Call

The call specifies the ValuesBeforeFirst and ValuesAfterLast arguments. SplitCriteria defaults to 'nosplit'.

SELECT * FROM Burst (
  ON finance_data AS input_table PARTITION BY id ORDER BY id
  ON time_table2 AS time_table PARTITION BY id ORDER BY burst_start
  USING
  TimeColumn ('start_time_column', 'end_time_column')
  TargetColumns ('expenditure', 'income', 'investment')
  StartTime ('06/30/1967')
  EndTime ('07/10/1967')
  ValuesBeforeFirst ('NULL','NULL','NULL')
  ValuesAfterLast ('NULL','NULL','NULL')
  Accumulate ('id')
) AS dt ORDER BY id;

Output