Invalid Derivatiton to Output column

vindewd · Post by **vindewd** » Sun Dec 13, 2009 5:15 pm

The job extracts Datawarehouse information and converts it into XML format that is accepted by the database.The output is non formatted XML output.

While compiling the Datastage job I get an Error"Invalid derivation to output column'

I didnt have any problem when i didnt concatenate the User defined variable

Could you provide me with pointers as to where it coulc have gone wrong???

jhmckeever · Post by **jhmckeever** » Sun Dec 13, 2009 11:45 pm

Crikey - Can you provide us with some more hints to go on? Can we assume the error is being generated by a Transformer stage?

You say that you didn't have a problem before you "concatenate(d) the User defined variable", so in answer to your question about where you went wrong I'll chance my arm and say that the problem is with the concatenation of the User defined variable.

Does "User defined variable" mean a job paramter, stage variable, or something else? What's the derivation that's failing? Can you show us the concatenation expression in question?

J.