TD Enterprise stage replaced with TD connector stage issue

shershahkhan · Post by **shershahkhan** » Wed Oct 22, 2008 9:46 am

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?

shershahkhan · Post by **shershahkhan** » Wed Oct 22, 2008 11:47 am

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

shershahkhan · Post by **shershahkhan** » Tue Oct 28, 2008 11:45 am

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 ?

toshea · Post by **toshea** » Thu Oct 30, 2008 11:20 am

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.