Hi, I'm new in DS job developmen and I triying to create a new job composed by:
CDC_Transaction->Transformer->JDBC_Connector
I test my results updating, inserting and deleting but, I have problems if I try to do a "Delete then Insert" operation.
My job crash because "I did'tn refer all my columns in the statemen"
My question is:
How I can directly refer a specific column in my job?
The value is set to NO.
I understand that the field should be worth YES, but I still don't know how to correlate the information I get with the specific columns I want to write.
You can see the SQL statement performing Delete and subsequent Insert in DataStage Director. Confirm that ALL columns that the connector can be paired with the target table.