What happens to a mapping if we alter the datatypes between Source and its corresponding Source Qualifier?

Question

I am using a mapping variable of date/time data-type and aggregation MAX In Source Qualifier SQL Override i am giving select col1,col2 from tbl where col1>$$dt

(col1 is also date data type)

When i am validating the query it is giving Invalid Query and error was

 [Microsoft][ODBC driver for Oracle][Oracle]ORA-00933 : SQL command not properly ended

I have also done extraction of characters like select col1,col2 from tbl where to_char(col1,'DD-MM-YY')>to_char($$dt,'DD-MM-YY') but still the same same

I am not getting what the error is and the same thing if i am trying for number column the it is validating fine and performing incremental extract also.

Any suggestions regarding the same will be helpful

Answer 1

The Source Qualifier transformation displays the transformation datatypes. The transformation datatypes determine how the source database binds data when the Integration Service reads it.
Now if we alter the datatypes in the Source Qualifier transformation or the datatypes in the source definition and Source Qualifier transformation do not match, the Designer marks the mapping as invalid when we save it.