Source Qualifier SQL Override Error with Mapping Variables

0
votes

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.

2
etlinformatica-powercenterinformatica

2 Answers

1
votes

I have used something like this below and it worked.

col1 > (TO_DATE('$$dt','MM/DD/YYYY HH24:MI:SS')

0
votes

I believe that you cant use mapping parameters/variables etc in source qualifier query (like you are trying).

However you can build the complete query outside, and pass it in using $$SQ_QUERY, effectively overriding the complete SQL statement.