adhocshare

Knowledge is Power

Category: EDW

0

EDW

pg_dump and pg_dumpall command helper (postgres)

  pg_dump pg_dump only dumps a single database. To backup global objects that are common to all databases in a cluster, such as roles and tablespaces, use pg_dumpall.Dumps can be output in script or archive file formats. Script dumps are plain-text files...

0

EDW

Introduction to CDC

Source: http://www.dwh-club.com/dwh-bi-articles/change-data-capture-methods.html Author(s): Bralgin, Igor   Introduction to CDC According as to its definition and to its aims, a Data Warehouse (DWH) must maintain the history of business measures’ changes. Thus the ETL processes of the Data Warehouse loading must...