Hi team,
I have to set the incremental load best practice in my proyect, I need to know if the steps that I do are correct.
First I set up the PK on ingest area.
after that I set up the incremental Load
Them in my Prepear area, I set on the tables incremental load.
To finish I set add Incremental Selection Rule
Are thes steps correct? Is this the way to set incremental load?
Thanks for your support
+8Hi,
if your tables are loaded incrementally in the Ingest, the automatic setting will automatically load incrementally from Ingest to Prepare. You don't need to set up incremental load explicitly. You do need to do that from one Data Area to another.
There are some slight complexities in the area of deletion handling depending on what you want to happen and how you want to be able to see that in Prepare. In general, I avoid turning those on in Ingest if I don't need them as they require pulling the whole PK set from source.
+5Hi
See my two guides for reference.
You do not need to change the table to incremental load, Automatic is enough if the source table is running with incremental load.
You need to check that the mapped table has the I icon to see that it is being incrementally loaded.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
