modifying data in thdw

View previous topic View next topic Go down

modifying data in thdw

Post  SnowShine429 on Fri Dec 19, 2014 5:53 pm

hi,

we built a dw for our marketing department and sometimes users go in and make changes to the dw from the back end. since we do incremental load of the dw, these changes are not over-written. how do we convince our business users that this a terrible method and that they should make changes in the data source?

SnowShine429

Posts : 36
Join date : 2013-02-16

View user profile

Back to top Go down

Re: modifying data in thdw

Post  ngalemmo on Fri Dec 19, 2014 8:43 pm

Well, chances are you probably need to find some middle ground.

First off, no user should have the ability to perform updates to the data at the database level (i.e. SQL UPDATE). All updates should be handled through an application and applied to the DW through established load processes. This gives you the ability to audit and control such activity.

In marketing it is not uncommon to have 3rd party or in-house data sources that are not covered by the enterprise systems. Sometimes its just stuff somebody has on a spreadsheet. So, you need to do some analysis. If the data is maintained on an enterprise system, find out why they are taking short cuts and develop solutions. One thing a data warehouse tends to expose are shortcomings in current processes. For external and spreadsheet type data, you need to put practices in place where the data is landed into a staging area then applied to the DW through a load process.

It really boils down to establishing a data governance process and empowering those on the business side to take ownership of the data and its quality. It's your job to see to it that processes and applications are in place to accommodate what they need to do.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: modifying data in thdw

Post  SnowShine429 on Sat Dec 20, 2014 11:12 am

thank you!

SnowShine429

Posts : 36
Join date : 2013-02-16

View user profile

Back to top Go down

Re: modifying data in thdw

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