When data remains unchanged, does Pentaho PDI SCD Type 2 still create a new row?

data
scd

asked 2021-06-21 11:00:00 +0000

david
31 ●16 ●4

edit retag flag offensive close merge delete

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2023-03-29 01:00:00 +0000

huitzilopochtli
41 ●4 ●3

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.

edit flag offensive delete link

add a comment

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools

Stats

Asked: 2021-06-21 11:00:00 +0000

Seen: 18 times

Last updated: Mar 29 '23

When data remains unchanged, does Pentaho PDI SCD Type 2 still create a new row? edit

1 Answer