Delta load for fact table.
Good day everyone.
I'm new to SAPDS, starting to build a DW from a retail sales system. What is the "best/must used/common" method to make the delta load of the fact table.
I've done delta load for dimension tables using table comparison, but I believe table comparision for fact tables is not a good idea.
Thanks in advance.
Dirk Venken replied
Everything you want to know about the DS Table_comparison transform can be found in Table_comparison transform: comparison method settings and performance impact in a nutshell
I use that transform both for target CDC of both facts tables and dimensions. If you want to achieve highest performance, you've got to combine with source CDC (based on last_modification timestamp, sequence number, log table, db-based CDC...).