Four Stars

Ora

Hi Team,

 

I am trying load into the target using incremental load. Attached screen shot for your references.

 

Main job: I am reading date values from reference table (test_src) and storing into the context variable.

-------------------------------------------------------------

Query: tOralce_1

 

SELECT
INCR_LOAD.INCR_DATE1
FROM INCR_LOAD
where INCR_LOAD.TBL_NAME='test_src'"

------------------------------------------------------------

And,Subjob based on date values is >(greater than context variable load into target table.) while doing i am getting below error.

Exception in component tOracleInput_2
java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected

 

Query: tOracle_2

 

"SELECT
TRN_REF_NO,
TXN_DT,
FROM TEST_SRC
WHERE xxx_TEST_SRC.TXN_DT >= ' "+context.Incrementaldate1+" ' "

 

Any suggestion on query.

 

Thanks

Shridhar

 

  • Data Integration
2 REPLIES
Ten Stars

Re: Ora

You may need to wrap your date variable with to_date.
Four Stars

Re: Ora

Hi,

 

I am tried with to_date still same issue.

 

Can you please send me full syntax?

 

Thanks

Shridhar