Agile Data Warehousing - DEsign Tip 111

Agile Enterprise Data Warehousing

I would really appreciate it if someone could just point me in the right direction with regards the situation Im faced with currently. The scenario: My team was tasked with implementing a data warehouse. This has been a challenge since the

SOA and Data Warehousing

Hello everyone.... I need your help here. I am working on some DW related roadmaps. I am stuck on role SOA(Service Oriented Architecture) is going to play in Data Warehousing ETL in- particular and BI in-general. Your comments on above mentioned are

New at BI and data warehousing and trying to make sense of it all.

Good evening gents! I am new on this site obviously and wanted to say hi before i start with my issue. now on to the issue. I am starting a data warehousing project from complete scratch for a small company that is getting off the ground. This is my

Data mart design

Lets say I need to model Frauds. There is 2 departments handle different Frauds say (Contract and Health care). I am going to model this in MD (fact, dimension). Now should I just create one Fact table(Business Process) and use say Fraud type (Contract,

Data Warehouse Purge Strategy - HELP

I'm looking at the best way to implement a purge strategy in a dimensional model. The reason to purge is that no personal data can be kept after 4 years, but the users would still want to see counts/facts by no identifying data. For example i couldn't

Data Warehousing Vendors (Manufacturing)

Dear Sir or Madam We are a local company located in Syria, specialized in Industrial Confectionary Development (Food; Biscuit, Chocolate and Juice) The company seeks to find consultants/ vendors in order to initiate a data warehouseing project to be

Managing Data warehousing Unit

I am working as data warehousing and Reporting manager. I am responsible of managing the unit and helping my Engineers in data modeling and ETL design and developing Reporting some times .I am also responsible of running any data warehousing projects

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Dimension Modeling Design challenge - Help Needed

Guys, Help me out identifying whats wrong with my model. I am able to get to the right data, but size of the fact table is arguably high and not gladly acceptable. Let me show you the picture (tip of the iceberg) Data table in transaction db is

Graphic Design Forum | GraphicsCode.net

GraphicsCode.net GraphicsCode.net specializes in graphic design and web design, providing you with free graphics, tutorials and other services. Show off your work, get feedback and request graphics. A place where you can have fun and adventures, and a

Data Vault v's Dimensional Model

Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here:

ForuMotion Coffee Mug Design

I just finished up my latest design which is a Fan Based art that I will be ordering very soon my own Official ForuMotion Coffee Mug from my design in photoshop. I drink coffee a lot and this way I will never have to forget about ForuMotion. I canno