Viewing 6 posts - 46 through 51 (of 51 total)
If I am not mistaken, it sounds like you are attempting to put transactional event data (DW Fact Table data) into a dimension table.
The first question you must ask yourself...
August 28, 2013 at 9:16 am
Depending on the culture of the establishment, immediate termination may not be possible. Even still, I would question the competancy of Evelyn. Why would she allow this behavior...
August 19, 2013 at 8:36 am
Thank you for the fine post. I have been a DBA for a long time (more than 26 years covering mainframe, unix, and Windows). In my earlier years, hierarchical...
November 8, 2012 at 9:03 am
Oops. I forgot to add a couple of other very important differences between BI/DW and OLTP.
In some shops, ETL processing will allow separate Operational Reporting on the...
October 16, 2012 at 9:16 am
There are several models to choose from when you consider data warehousing. Some physical models are "purists" and would never conceive of having a child to a dimension table...
October 16, 2012 at 9:04 am
There is way too much to cover here in a post. It is something that experienced DBAs can hash over for weeks. But I will share a couple...
July 18, 2012 at 4:09 pm