DSXchange

I select the Generated SQL Query. When I choose view data, I get a message about some fields and tables not in my job. I paste the query into Oracle and it runs fine. I switch to User Defined and the view data works fine. Has anyone else had this experience?

Your query is based upon the derivations on the column tab of the drs stage. I have seen this happen when the column name on the tab does not exist in one of the tables, regardless of the derivation. I know this "feature" has been fixed at 7.5.1A.