Well, without seeing the entire script, what you have shown me is a Selector operator retrieving 2 DECIMAL columns and a VARCHAR. Therefore, your schema must match.
I am getting error even after giving excat match in schema as database defn.
only one thing I case see as issue is DATE column. in TPT it's saying either ANSIDATE or INTDATE is to be give, I have DATE column in database with format 'YYYY-MM-DD' what should be done to resolve this issue.
I have TPT 13.10.00.02
Geeta A. Gwalani
It is not so much the FORMAT, as whether the data is being exported as an integer value, or a character string. If you are telling the database to export the data in ANSI date mode, then your schema has to be ANSIDATE. IF you are not, then you need to specify INTDATE.