Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

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...).

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question