Hi,
How incremental load works from any data source(other than anaplan) to data hub in anaplan?
In short, it doesn't
You will need to produce a file from the data source that only contains the new records
You should include a column that contains TRUE and import this as part of the data load to the hub.
Then use can use that flag to filter on the data when sending it down to spoke models
David
Can you elaborate more on your question, I assume you mean incremental load as what is newly created, what has changed since last data collection. ERPs/Source application has a creation_date, last_modified_date on the transaction tables. From the source, they can identify the incremental set of records and provide to us. On our side, if the record is new, it gets created, if it is existing, it gets updated with latest data. Anaplan's integration on complete collection (load) and incremental collection (load) is same as other applications.
It makes sense to collect only incremental data rather complete data everyday.
Thanks
Arun
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Hello community, I have an issue with anaplan report (functionality). The issue I have is within couple of slides. The data in that report is scrolling into a new page. There is a hierarchy in the rows and line items and time in the columns. My problem is, the hierarchy is getting broken in the second page. One of the node…
I want to create an S3 connection that will have monthly data stored in individual csv files that is connected to ADO. Around month end, data will be uploaded multiple times, replacing existing csvs. When this happens I want to replace the existing data for that month with the new file. I don't want to have to create a…
