DRAFT ETL+ Load Replace NOTES

My notes: info to include in public docs

Transactional Table vs. Entity Tables

Replace typically used with Transactional tables. Easier to configure with transactional data.

Fixed Date

Do not use a last-update-datetime! Last modified date-time

Use Create date, Invoice date -

If that doesn’t work then use Upsert

Replace to Remove Deleted Records

strategy: (Fine tuning in Joni’s words) – Upsert, Replace (less often), Load All (even less often)

OData 1 min = 10,000 rows – some much slower