Teradata table laod ERROR
Posted: Fri Nov 30, 2012 8:24 am
Hi All,
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
In the job design in transformer I eliminated the column change_code.
Could you please help me on this?
Thanks
Sunitha
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