I have a simple job which loads a table data from Oracle to Netezza DB.
Job is like this.
Oracle Stage -> Transformer -> Netezza Stage.
It was working fine few weeks ago.
But suddenly its not working now and getting aborted with the following error message.
Added field has duplicate identifier()
I know this happens because of RCP enabling. But I didnt understand the duplicate column name part.
Still I cross checked it and i didnt find any repeating column names in both the DB stages.
Anyone who have come across this kind of error ?
Any guidance will be highly aprreciated.
No Craig. And I have made sure that I have reimported the latest metadata to prevent accidental metadata mismatch.
But still I am getting this error.
Is this a bug in Datastage ?