I searched the forum under the topic user defined sql but i didn't get any solution to my query.
My job looks like
Oracle ------Transformer------Oracle
Source table has 4 columns and Target table has 3 columns.
Iam using user defined sql to Create Target Table and Load Data to that.
Code: Select all
CREATE TABLE TOPNOMINEE1 AS (SELECT RANK, NOMINEE, TARGET FROM DISCOVER.TOPNOMINEE)
When I run the job, it aborts with fatal warning. The observations in Director, Designer and Toad are
In director
DbRefIntg...target: User defined SQL is a required link property
Attempting to Cleanup after ABORT raised in stage DbRefIntg...target
Job DbRefIntg aborted.
In Designer
LINK: RED colors
View Data:Required Data
In Toad
Required result.
I can view the Source and target data
My question is
Why the job aborts or the link is red when the data are loaded to the target table?
What is the warning DbRefIntg...target: User defined SQL is a required link property
Thanks in advance
kcs