Loading Dimension table with Type 1 SCD in ETL process
Page 1 of 1
Loading Dimension table with Type 1 SCD in ETL process
Hi at all
I'm a new entry in this forum and I'm a beginner with use of data warehouse and ETL process.
As the title of the topic I face to load the dimension tables of a data warehouse with type 1 SCD.
My doubt is regarding to choice of type 1 attribute to configure UPDATE/INSERT in the ETL tool.
What I want to ask, if possible, is the business key the correct attribute for UPDATE/INSERT? .. It's the only attribute for UPDATE/INSERT?
Thanks in advance.
I'm a new entry in this forum and I'm a beginner with use of data warehouse and ETL process.
As the title of the topic I face to load the dimension tables of a data warehouse with type 1 SCD.
My doubt is regarding to choice of type 1 attribute to configure UPDATE/INSERT in the ETL tool.
What I want to ask, if possible, is the business key the correct attribute for UPDATE/INSERT? .. It's the only attribute for UPDATE/INSERT?
Thanks in advance.
gstars- Posts : 10
Join date : 2013-04-05
Re: Loading Dimension table with Type 1 SCD in ETL process
Has anyone some idea at regards?
gstars- Posts : 10
Join date : 2013-04-05
Re: Loading Dimension table with Type 1 SCD in ETL process
The business key is used as the key by the ETL process to find the existing dimension row to update. For SCD1, any of the attributes of the dimension can be updated at any time (that is, any fields in the dimension other than the surrogate key and the business key can be updated.)
VHF- Posts : 236
Join date : 2009-04-28
Location : Wisconsin, US
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum