DSXchange

Orignal Job:
Target Stage = TD Enterprise stage
RCP = ON
Silently Drop Column = TRUE

Changed JobTarget Stage = TD Connector stage
RCP = ON

PROBLEM The jobs is dynamic job can be called for different tables i am looking for any option which can be used if there are extra columns coming from income stage which are not present in the target then they should be ignored, any such option available in Teradata connector stage?

I make it work : Schema reconcilition -> unused feild action = drop

Have to reopen as Schema reconcilition -> unused feild action = drop does not work although i thought that is what documentation says. Have done a workaround by using a modify stage and added the drop column specification. Please let me know if there is a direct way of droping the column ?

What do you mean it doesn't work? That is exactly what the Drop option is for. If it's not working, get patches for Ecases 130419 and 130045.