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.

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


"AKaramatullah (AT) gmail (DOT) com" <AKaramatullah (AT) gmail (DOT) com> wrote

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.