February 18, 2008 at 9:35 am
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
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