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
I have a requirement to extract last 90 days data from an Anaplan model through Matillion. I wanted to know is there any API which I can use to achieve the same? I have taken a look at the (Integration APIs) Bulk API as well as Transactional API and none of them has a relevant query parameter which I can use to apply the…
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…