Incremental Load Error

[#1]

Hi All,

I'm trying to do a Incremental Insert and Update Load on Update Date. I'm getting a syntax error. Can someone provide assistance.

Thanks in Advance,

[sunny_talwar]

Not having null doesn't mean that a field is unique. To know if it is actually unique, you need to do a DISTINCT Count to make sure that it matches the number of rows that the database has it.

[#3]

Yeah afterwards I did a Distinct pkdim1customercuration function and it gave me the 292,278 rows which is the total number of rows in the table. I don't know what's the issue here; I'm following all the instructions. Update date is the last modified date in the DB tables.

LET vLastRunTime = Date(Today(), 'DD-MMM-YYYY'); Can this be the problem?

[sunny_talwar]

I don't think the variable is an issue here. Would you be able to share the log file from your last incremental load?

[#5]

Got it......I had to reload the original alongside with the updated reload and then comment out the old/original one.

Thanks for all your help you guys.