ARIMAPredict Example - Teradata Vantage

Input

Input tables are ARIMA Example 1: OrdersTable, PartitionColumns, No Seasonality output:

• ModelTable: arimaex1_model
• ResidualTable: arimaex1_residual

SQL Call

SELECT * FROM ARIMAPredict (
  ON arimaex1_model AS ModelTable PARTITION BY id_partition
  ON arimaex1_residual AS ResidualTable PARTITION BY id_partition ORDER BY period
  USING
  StepAhead (10)
  PartitionColumns ('id_partition')
 ) AS dt;

Output