Direct Update to Dimensional Tables in a Independent Data Mart

View previous topic View next topic Go down

Direct Update to Dimensional Tables in a Independent Data Mart

Post  FiveKids on Sat Mar 09, 2013 12:11 am

I am a little new to this type of design of Data Mart.
I am creating a DATA MART in a star schema design. I will having data feed that will be staged and etl into the Data Mart which is normal process but the client would like to update some of the dimensional directly. Those dimension would be in a admin screen type to access for update.
Have anyone heard this type a design or practice and is this ok?

FiveKids

Posts : 2
Join date : 2013-03-09

View user profile

Back to top Go down

Re: Direct Update to Dimensional Tables in a Independent Data Mart

Post  ngalemmo on Sat Mar 09, 2013 11:26 am

It is unusual. First, I would find out what and why. Are they trying to 'fix' a problem in the wrong place or are they simply providing additional attributes that are not available anywhere else?

If you do permit it, separate what can be maintained in this manner from what is coming from the source system. If it means keeping two versions of the same attribute, so be it.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Direct Update to Dimensional Tables in a Independent Data Mart

Post  BoxesAndLines on Sat Mar 09, 2013 6:11 pm

I've seen it where the business wants to add a description to a new code value. The process worked well enough with no problems. Normally, the particular values being updated were not in the normal ETL process. Otherwise, they'll just get overwritten.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Thank you so much for your reply

Post  FiveKids on Sat Mar 09, 2013 7:53 pm

They would like more of real-time on specific areas of the data mart instead of waiting for the nightly batches to run to push the data to the Mart.
The fact tables is at a daily transactional level. The client wants to updates the records multiples time during the day...

But the Dimenison tables is where client
would Like to do something like adding/updating a person name and
changing a person work schedule at daily level.

FiveKids

Posts : 2
Join date : 2013-03-09

View user profile

Back to top Go down

Re: Direct Update to Dimensional Tables in a Independent Data Mart

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