Yes, even when data remains unchanged, Pentaho PDI SCD Type 2 still creates a new row. This is because SCD Type 2 is designed to track changes to data over time and preserve historical records. By creating a new row, any new data that is entered will be attached to the correct historical record, allowing users to view and analyze changes to the data over time.
Asked: 2021-06-21 11:00:00 +0000
Seen: 18 times
Last updated: Mar 29 '23