DSXchange

Hi

Trying to create a simple job where i move data from oracle to netezza.
Running the query
SELECT "DMDUNIT", "DMDGROUP", "LOC", "STARTDATE", "DUR","TYPE","FCSTID", "QTY" AS ANT, "MODEL" AS MODELL, "LEWMEANQTY","MARKETMGRVERSIONID"
FROM "db1"."production" WHERE ROWNUM < 10

fail with the following error
TR_Transformer: Error when checking operator: Could not find input field "ANT".
Error when checking operator: Could not find input field "MODELL".

Running the same query directly to oracle works, but in datastage it fail.

I do not understand what happends

Please advise

Dan

Why are you aliasing the columns? Does it work if you remove them? The aliases, not the columns. Regardless, they need to match to the column names in the stage.

There are some situations where you need to ensure that the output column definitions precisely match the order of the SQL statement. You did define the output columns, right? RCP can not work without a source -- and you need to define that source.