Bi Cloud Extract is returning different amount of lines with same parameters
Summary:
BICC Extract Difference in amount of lines using same parameters
Content (please ensure you mask any confidential information):
I'm using BI Cloud Connector, data extract "FscmTopModelAM.FinXlaJrnlEnterJrnlAM.JournalEntryLinePVO" to extract XLA Lines.With Option "Use UNION ALL for incremental extract" uncheked and query filter "(TIMESTAMPDIFF(SQL_TSI_DAY, DATASTORE.XlalinesLastUpdateDate,CURRENT_DATE) <= 5)" to extract lines from 5 days before.
However, executing one after another manually, shown very different amount of lines. In an example the first run show 858301 (resetting the data store), and 5 minutes later, executing the same datastore with same parameters show 214052. I'm expecting a similar number of lines as there has not been recent lines in that time frame.