Best practice to Load Fact table in MS SSIS

sql-server-2008 ssis data-warehouse fact
Saboor Awan picture Saboor Awan · Jun 13, 2011 · Viewed 9.1k times · Source

I am new to SSIS in data warehouse. I am using Microsoft business intelligence studio.

I have 5 Dimensions each having some PK. I have a Fact table that contains all the PK of Dimensions, means their is a foreign key relationship exist ( as in star schema).

Now what is the best practice to load the fact table.

What i have done is write a cross join query between 5 Dimensions and the resultant set is dumped to the fact table. But i don't think this is a good practice.

I am completely new to MS SSIS. so plz describe suggestions in detail.

thanks

Answer

Damir Sudarevic picture Damir Sudarevic · Jun 13, 2011

Take a look at Microsoft Project Real examples. Also get a Kimball book and read-up on loading fact tables -- the topic covers several chapters.

Related questions

How do I fix 'Invalid character value for cast specification' on a date column in flat file?

I have a CSV file with a {LF} delimiting each row and a date column with the date format as "12/20/2010" (including quotation marks) My destination column is a SQL Server 2008 database table of type date (not datetime) In my Flat …

Read More
Update Rows in SSIS OLEDB Destination

I have a data flow process where I have an OLEDB Source and an OLEDB Destination like below: Source merges data from two staging tables and returns a result set (say, 50K rows). These 50K rows are present in the …

Read More
How to increase MaximumErrorCount in SQL Server 2008 Jobs or Packages?

I have several jobs and several packages. In SQL Server 2005 we used to use DTS Packages, but they are now defunct (I know that I can re-enable them, but that's not what I'm after). I receive the following error by …

Read More