I m getting this error when i run a job having multiple Oracle tables with one SQL Query having in SQL Transform.
Data Services Management Console
(14.2) 04-20-17 22:10:31 (E) (88784:89388) VAL-030147: |SESSION JOB_DM4113_DAILY_NEWS_TCPN_DMN|WORKFLOW WF_DM4113_TCPN_DMN|DATAFLOW DF_DM4113_TCPN_ICSPM_STG|STATEMENT <GUID::'90e74271-18b2-407a-a7de-0fc3dab2a12c' TRANSFORM SQL OUTPUT(DM4113_TCPN_DMN_V)>
Transform <SQL> requires option <sql_text> to be set
Is anyone have an idea about this error. Here are the details:
Please assist on how to resolve this Issue. Using SAP Dataservives 4.2 SP8 version with Oracle 12c client.