sql server dts: Populating fact table : SSIS : SQL Server 2005 -- sql server dts

Populating fact table : SSIS : SQL Server 2005

AKaramatullah NO[at]SPAM gmail.com
11/7/2005 2:01:17 PM

sql server dts: I'm new to SQL DTS services. Am trying to build a test data warehouse
on SQL Server 2005 and I have 4 dimensions and a fact table. The
dimensions contain auto generated keys. In the fact table, there's a
single field that depends on the combination of the foreign keys that
come from the dimensions.

I can't figure out a way to populate the fact table. Any help in this
regard will be greatly appreciated.

Re: Populating fact table : SSIS : SQL Server 2005

Allan Mitchell
11/7/2005 10:12:58 PM

You have single attribute in the FACT table that is effectively a smart
key to 4 dimensions?

How then do you pivot on values?
How do users add dimensions/hierarchies/levels to an axis?

If that is the way you have it then you can use Lookups to retrieve the
dimension key values and then use a Derived Column Transform to generate
the smart key

Allan

[quoted text, click to view]

Re: Populating fact table : SSIS : SQL Server 2005

nFactor
11/8/2005 12:04:11 PM

Thanks for the prompt reply Allan.

I'm using a typical star schema. The dimensions have auto-generated
PKs. These are FKs in the FACT table plus one attribute (say 'XYZ' for
reference) that's BASED on the FKs combination.

Using SSIS, I have been able to clean the data. Now, I need some way to
populate the DIMENSIONS and the FACT table such that I have the correct
value for XYZ for every combination of the FKs that exists.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.