Direct Update to Dimensional Tables in a Independent Data Mart
3 posters
Page 1 of 1
Direct Update to Dimensional Tables in a Independent Data Mart
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?
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
Re: Direct Update to Dimensional Tables in a Independent Data Mart
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.
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.
Re: Direct Update to Dimensional Tables in a Independent Data Mart
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.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Thank you so much for your reply
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.
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
Similar topics
» Data Mart/Dimensional Data Store Definition.
» Accumulating Snapshots: Can we update the non-milestone dimensional data associated with the shapshot?
» Merging two Data Mart tables
» Modeling Fact Tables that have direct relationships, but at a detail and not a dimension layer
» Dimensional update but no new facts
» Accumulating Snapshots: Can we update the non-milestone dimensional data associated with the shapshot?
» Merging two Data Mart tables
» Modeling Fact Tables that have direct relationships, but at a detail and not a dimension layer
» Dimensional update but no new facts
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum