Sparse Snapshot Loading


I was able to load data based on changed date I.e if any change occurred between yesterday and today by using below statement in Update query  

where UpdateDate>?

UpdateDate - datatype is DateTime

this method is working only for daily loads and not Intra day loads (intra day loads factors in time as well).

? ->considers only dates and not time ?? if so then how should we address this issue

4replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • See if the data type of update date can be made a timestamp . Alternatively you can reprocess the rows by putting 1 day offset , e.g. the filter as > ? - 1  

    • Amit Kothari 
      Hi Amit,

      DataType for UpdateDate in Incorta is timestamp.  if I include >?-1 its throwing an error
      INC_005004001:Failed retrieving sample data from [sample data] at [TestData] due to [com.microsoft.sqlserver.jdbc.SQLServerException: Operand type clash: datetime2 is incompatible with int] with properties 


      Does Incorta allow intraday loading? if so then how?

    • Prudhvi Raj Yes it does , please log a support ticket as ? should work .

    • Amit Kothari Amit Kothari  OK. will log support ticket

Like Follow
  • 1 yr agoLast active
  • 4Replies
  • 86Views
  • 2 Following

Product Announcement

We are happy to
announce Incorta 4.8 !!!