Where Clause issue in incremental loading

[dseelam]

Hello Guys,

I am facing this issue with incremental loading guys, any suggestions

"CANCELLED_DATE" is coming from one of the views in Oracle

am using date( "CANCELLED_DATE,'MM/DD/YYYY'" ) as CANCELLED_DATE but still it is taking it as a num

Thanks in advance

[Gysbert_Wassenaar]

10 divided by 31 divided by 2016 is a number. Perhaps you meant to use single quotes: '10/31/2016'. Or if oracle doesn't understand that try to_date('10/31/2016','MM/DD/YYYY')

[dseelam]

Hello Gysbert,

Thanks for reply

when I use to_date('10/31/2016','MM/DD/YYYY') in where clause I got this below error

FROM APPS."XXHSP_DB_CANCELLED_LINES_V" where "CANCELLED_DATE" >to_date($('Last_Updated_Date','MM/DD/YYYY'));

if I use other way around as you told 'single quotes'

I got this error

[sunny_talwar · Accepted solution]

Try this (I think you misplaced the single quotes and the parenthesis):

ROM APPS."XXHSP_DB_CANCELLED_LINES_V" where "CANCELLED_DATE" > TO_DATE('$(Last_Updated_Date)','MM/DD/YYYY');

[gandalfgray]

Hi

I think you got the quotes wrong, they should be around your date value.

Should be like this I think:

SQL SELECT * FROM APPS.XXHSP_DB_CANCELLED_LINES_V where CANCELLED_DATE>'10/31/2016'

[dseelam]

Hello Sunny,

I got this doubt, Once implemented section access

there is no need to reload whole data from oracle right (initial load)

I just can start from 2nd step loading from QVD ?

[dseelam]

Goran,

Thank you I got it sorted out

[sunny_talwar]

If you have stored the data in a qvd and you think that it doesn't need to be updated, then sure you can load from QVD

[dseelam]

Yes whole data is stored in form of QVD in initial load after that I just bring data with last updated date, concatenating with existing QVD where ID not exists and Inner joining with ID's and storing them in QVD which should store the data right ?

[sunny_talwar]

Seems like you are doing an incremental load. If you are doing it right, then ya, you should be able to pull data from your qvd