August 16, 2003 at 2:05 am
hi all,
i have made dimensions using DTS.My DTS package takes data from an oracle database and makes dimensions in a SQl database.The problem i m facing is that i want my FACT tables to use some identity columns or keys of the dimensions in the fact table.Any suggestions as how this is possible.i would be very grateful..thnx
August 16, 2003 at 6:08 am
Typically you'd do this using look-ups but these are a little slow in DTS (SQL 2K). If you can, load your data to a staging table and do your 'lookups' using joins (ie do a join to the dimension table on the descriptive column and return the key from the dimensional table). This will work quite a bit faster (depending on different factors) but can make for some messy TSQL if you have a lot of dimensional tables. Also becomes fun if you are trying to do a single pass to get all foregin key values AND handle nulls/unknowns.
Good luck, hope it goes well.
Steve
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply