Skip to main content
Question

can a Delta load be configured based on string column instead of changing date field

  • Nov 22, 2022 5:32 AM UTC
  • 1 reply
  • 87 views

sree.c
Level 7
can a Delta load be configured based on string column instead of changing date field

1 reply

  • Nov 22, 2022 7:00 AM UTC

Yes. We were doing last month several delta loads based on the _CAS_KEY id that was a string. Something like "column" like '20221101%'

In our case, as you see, the initial chars of the case_key codified the date

HTH