fleet_assigner_query_as_view.sql

CREATE OR REPLACE VIEW db_dev.revenue.fleet_assigner_vw
AS
SELECT
    airline_code || LPAD(flight_number, 4, 0) ||
    TO_CHAR(depature_date, 'ddMMyyyy') ||
    depature_airport ||
    arrival_airport ||
    flight_cabin ||
    booking_class
    AS FA_OUT
FROM
    db_dev.revenue.od_forecast_booking_stream;

SELECT * FROM db_dev.revenue.fleet_assigner_vw;