Teradata table laod ERROR

[sunitha_cts]

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

Code: Select all

td -ccd -lkp- transformer -funnel -td
     |
    td

In the job design in transformer I eliminated the column change_code.



Could you please help me on this?

Thanks
Sunitha

[kwwilliams]

You likely have RCP enabled in the job turn it off. In the Teradata connector you can also tell it not to abort the job on unused metadata.

[sunitha_cts]

Thanks William,


I had used a modify stage stage to do this it worked .

Thanks
Sunitha

[abhijain]

TD Connector has a property
"Unused Field Action" under the "Session" tab. it has drop down with 3 options - "Keep/Abort/Warn/Drop".

During execution, datastage verify the schema columns with columns available in table.

by default, this property is set to "Abort", due to which your jobs is aborting.

Since, it is trying to search, Change_code column in your table definition.

Change this setting to "Drop", will solve your problem.