I'm trying to use a CCD stage to capture the delta data loaded.
The design is 2 teradata connector stages connected to CCD stage and the target stage is teradata connector stage.
I'm unable to eliminate the change_code column from the preceding stage.
the records are loaded till the last link except the target teradata connector stage.
The job is aborted with the below error.
The error is "Teradata_Connector_36,0: RDBMS code 3810: Column/Parameter 'IDWD_DETLSRCSTAGE.STG_PERSON.change_code' does not exist. "
the design of the job is
Code: Select all
td -ccd -lkp- transformer -funnel -td
|
td
Could you please help me on this?
Thanks
Sunitha