Tag:Full scale
-
Time:2021-2-9
1. Background What is zipper table? When building a data warehouse, it is an important way to process table data. Data structure can be compared with algorithm, and zipper table can be compared with data warehouse. The purpose is to solve the SCD requirements in building a data warehouse. Then what is SCD? It is […]
-
Time:2020-11-17
Introduction:When ODS layer data synchronization, we often encounter the model of incremental total volume consolidation, that is, T-1 day increment Table + T-2 full scale = T-1 full scale. You can use the full outer join script to complete the merge, but when the amount of data is large, it is very resource consuming. This […]