settingsLogin | Registersettings
Scalefree
Show Menu

Incremtental to FACT

0 votes
Where can I find information about the best way create incremental loads from DV to Fact and Dim tables ?

-RAZ-
asked May 19, 2016 in Modelling by raz (120 points)

1 Answer

0 votes
RAZ, it all depends on what tool you are using for ETL, if you are using any. I count on Pentaho Data Integration for it, so I'd only have to fetch a couple of steps to compare from-DV to from-DM data and single the changed dataset (which is then subsequently treated/loaded/used for updates.)
answered Jun 21, 2016 by fabio (410 points)
Hi Fabio and thanks for the reply. I am using Integartion Services from Microsoft. What I am specially looking for is the best practice for getting the changed data that should be updated into the datamarts. How that is done and with what functionality.
-RAZ-
Scalefree Scalefree

Upcoming Trainings

  • July 01 to 03 - Amsterdam (English) Data Vault 2.0 Boot Camp and Certification

  • August 05 to 07 - Berlin (German) Data Vault 2.0 Boot Camp and Certification

  • September 9 to 13 - Hanover WWDVC EU

  • September 16 to 18 - Brussels (English) Data Vault 2.0 Boot Camp and Certification

  • October 21 to 23 - Hanover (German) Data Vault 2.0 Boot Camp and Certification

  • November 18 to 20 - Amsterdam (English) Data Vault 2.0 Boot Camp and Certification

  • December 02 to 04 - Dusseldorf (German) Data Vault 2.0 Boot Camp and Certification

  • December 16 to 18 - Zurich (English) Data Vault 2.0 Boot Camp and Certification

  • Contact us for inhouse training engagements.
    Visual Data Vault: Logical Modelling for Data Vault - Free Download!
    Scalefree
    DataVault.guru is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 United States License.
    Permissions beyond the scope of this license are available in our license.

    DataVault.guru | DWH Wiki | Recent questions RSS feed | Imprint | Provided by Michael Olschimke
    ...