Loading Dimension table with Type 1 SCD in ETL process

View previous topic View next topic Go down

Loading Dimension table with Type 1 SCD in ETL process

Post  gstars on Sat Apr 06, 2013 6:16 am

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.


gstars

Posts : 10
Join date : 2013-04-05

View user profile

Back to top Go down

Re: Loading Dimension table with Type 1 SCD in ETL process

Post  gstars on Mon Apr 08, 2013 4:25 pm

Has anyone some idea at regards?

gstars

Posts : 10
Join date : 2013-04-05

View user profile

Back to top Go down

Re: Loading Dimension table with Type 1 SCD in ETL process

Post  VHF on Thu Apr 18, 2013 2:14 pm

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

View user profile

Back to top Go down

Re: Loading Dimension table with Type 1 SCD in ETL process

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum