Type 1 Slowly Changing Dimensions

KNIME Analytics Platform
1

Could you please tell me about how to use Type 1 Slowly Changing Dimensions (SCD) in KNIME and what are the nodes required.

Thanks in Advance.

2

Hi @syembarwar,
What do you mean by “use”? SCDs are more a database issue than a data processing issue, and KNIME only does the latter. You can retrieve a SCD from a database like any other data, with DB Connector, DB Table Selector, DB Reader and others.
Kind regards,
Alexander

1 Like
3

Thanks for your response Alexander,

I want to implement Type 1 Slowly Changing Dimensions (SCD) in KNIME. It is possible to apply in KNIME?

4

EDIT: I was wrong here. If you try to insert a a row with an existing primary key, you will get a key conflict error. As @syembarwar mentions below, DB Merge is the right node to use.

Hi,
So you just mean how you can overwrite data in your data warehouse (Type 1 SCD)? You only need a DB Writer or DB Insert for this. As long as the primary key already exists, the existing entries are overwritten automatically by your DW.
Kind regards,
Alexander

3 Likes
5

Hi Alex,

Yes, I want to overwrite data in data warehouse using (Type 1 SCD). I will try using this node DB Writer and DB Insert.

Thank You!

6

Hi Alex,

This is done with the help of DB Merge Node.

Thank you.

2 Likes
7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.