Post reply

First Datawarehousing project...need some help and input !!

  • February 18, 2008 at 9:35 am

    #779374

    Thanks, i had to add the linked server prefix as well. Moreover, i also had to add square brackets for some reason for it to finally work...

    [server].[database].[owner].

    With regards to the cube, what i meant was, is it required for building reports using SSRS. Would i get the same level of performance if i had the data for fact tables and dimensions residing on SQL server(instead of SSAS).

    I basically need to get some reports out soon.

    I plan to read some more whitepapers on this from the MS site ..after im done inserting into the staging area, so yeah i will be looking more deeply into it. Thanks for your suggestions so far ...!

    Happy Monday..!

  • February 20, 2008 at 9:39 am

    #780275

    I finally got it done

    I removed all duplicated from customers table, then insert corresponding addresses and ssn..annd so forth.

    Created a temp table, removed the duplicates and updated the original table.

    I would have to do a larger number of updates and group by statements but it seems to be the most efficient way for now, till i create some sort of script or package using SSIS.

    Thanks for all your help,

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply