ETL Auditing standards and how to implement them.

Audit dimension for a dimension?

The books describe how to create a useful audit dimension for the fact table rows, but what about the dimension table rows? Why isn't that mentioned in the books? Isn't the data quality and lineage also important for dimensions? Would you create a

Audit Dimensions in SQL/SSIS 2008

I've read The Micorosoft Data Warehouse Toolkit and would like to implement the audit dimension and logging set up described in that book. However, I believe the download from the book's site is for SSIS 2005. Has anyone published an updated framework for

SET1/Q.1 Discuss Is Auditing is a luxury.

Q.1 Discuss Is Auditing is a luxury.

Looking for BI performance standards (response time)

We are trying to establish bench mark for BI report performance. Is there any Industry Standards on BI reports response time, like What is the average response time for an average standard report. Average response time for drill down/drill throug

How to implement a data warehousing solution for Google Analytics data?

I have click stream data such as referring url, top landing pages, top exit pages and metrics such as pageviews, number of visits, bounces all in Google Analytics. There is no database yet where all this information might be stored. I am required to

Adhering to standards for greater development

Consider the following table on the desirable density of dwelling units for different areas developed by the planning authorities. For ideal city development, adhering to certain standards helps a

SET2/Q2. What are the mandatory standards of ICAI?

Q2. What are the mandatory standards of ICAI?

Iraqi company to implement project of trade zone

Iraqi company to implement project of trade zone Monday, March 22nd 2010 7:56 PM Basra, March 22 (AKnews)- The Secretary of Investment board in Basra, Jalal Noori, said Monday that granting the license to the project of trade zone border with Ira

Peace Sumaisem's (citizen): can not implement a project to raise zeros from the currency in the absence of Parliament and Government

Peace Sumaisem's (citizen): can not implement a project to raise zeros from the currency in the absence of Parliament and Government Baghdad - Al-Abdullah Ok Excluded expert economic Sumaisem peace that is applied to the project raise zeros from the

Feederlines B.V. Implement GL's Fleet Management Software

Onboard of 48 ships of Dutch shipping company Feederlines B.V., GL Maritime Software's fleet management software GL ShipManager and GL FleetAnalyzer will be implemented in 2011. Feederlines B.V. has chosen to use the Technical Management, Procurement,

time relatives - YTD, MTD, QTD the best approach

What are the various design options for calculating fact by YTD,MTD, QTD for multiple different calendars?

Bridge tables versus massive junk dimensions

I am designing a star schema to store information on hospital stays. This is my first real star schema and things are off to a good start. My fact table is hospital stays. I have a diagnosis dimension. There are multiple diagnoses per stay. Costs are

New Customs / Tariff Law News

18/01/2011 In what the Deputy Governor of the Central Bank in increasing state revenues BAGHDAD - Haider al-Rubaie Filaih While moving the government to implement the tariff law to talk early next March, warned specialists from the consequences of a