TDA cannot regenerate the view definition when connected to Netezza. Right clicks on the view in the Explorer | Generate SQL | To Editor | Creation Script generates incorrect scripts.
>>>Expected script to create view
CREATE VIEW VW_TEST AS
SELECT a.*
, CASE WHEN b.some_status = 'Completed' and REVENUE > 0 then 'Y'
WHEN b.some_status <> 'Completed' and CUSTOM > 0 then 'Y'
ELSE 'N'
END IS_VALID_REVENUE
FROM DEAL_FEES a join HIST_DEAL_STATUS b on
a.status_dim_id = b.status_id
;
>>>Actual script Toad regenerates (From < table_name> is wrong and there is no definition of IS_VALID_REVENUE).
CREATE VIEW VW_TEST AS
SELECT INTERVAL, INTERVAL_ID,….., IS_VALID_REVENUE FROM <table_name>;
