Audit Dimensions in SQL/SSIS 2008

SSIS and the SQL 2008 MERGE Statement for Insert, Update and Delete

The 'MERGE' statement in SQL 2008 seems a powerful tool for managing incremental ETL. Seems lots of examples of using from SSMS, but few (none?) of calling from within the SSIS framework. Hopefully in Denali we'll see a package object OOTB that can

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

Historical and Incremental Loading of Dimension and Fact tables

Hello I have been reading three of the Kimball books and playing with the MDWT_AdventureWorks_SSIS sample. I have learnt a lot but I have also become overwhelmed as I was new to DW/BI up until a few weeks ago. Also, the books are very detailed and ther

HR Audit Question

Dear Sir / Madam, Plz send the answers for the following questions? Q.1 Explain Objectives of HR Planning. Q.2 Write a note on Major Human Resource Development Strategies. Q.3 Discuss the approaches of HR Audit Q.4 Explain preliminary steps

SQL Server 2008 Date data type as dimension key

We are getting ready to migrate from Microsoft SQL Server 2005 to 2008. Currently we use an integer (in YYYYMMDD format) as the SK on our date dimension table. I am very tempted to start using the new 3-byte Date data type (which stores only the date

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

SSIS SCD Component

We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/). We have run into a few issues and would appreciate some advice if anyone has used this SSIS

Board of Supreme Audit checks 70% of the country budgets for previous years

Board of Supreme Audit checks 70% of the country budgets for previous years 16/11/2010 09:51 Baghdad, November 16 (Rn) - The Board of Supreme Audit of Iraq, Tuesday, missed all the advanced stages to end the review of financial budgets in

Contact for SMU BBA, MCA, MBA solved assignment and final project report

SMU BBA, MCA, MBA solved assignment and final project report All Type Of IGNOU, SMU, KSOU, MDU, IMT Ghaziabad Solved Assignment And Helps in final project report/ Thesis/Dissertation MDU, SMU, GJU, IGNOU etc. univeristy Regards studentsupport

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Favourite B-Sides

Elbow's B-sides are generally better than most bands' A-sides... what are your favourites? Here's mine, in no particular order. Love Blown Down - should've been on an album, it's brilliant! George Lassoes The Moon - I think it's the Noisebox

Elbow tour 2008

Just to set the announcements off, here's the dates of the upcoming elbow tour. 4 Apr 2008 19:30 ABC - SOLD OUT! Glasgow 5 Apr 2008 19:30 academy newcastle 6 Apr 2008 19:30 met uni - SOLD OUT! leeds 8 Apr 2008 19:30 academy - SOLD OUT!

ETL from Oracle to SQL Server 2008 Data Warehouse

Hello, Our data warehouse runs on SQL 2008 servers. One of the transactions systems we have runs on an Oracle database and managed by a separate team. What are the recommended methods to extract source data from an Oracle database and loading to a