Is it a must in star-schema modeling that we have a single fact table?In essence can we have multiple fact tables in a cube and still arrive at a star-schema model. Thanks Current

Thanks your response. I just wonder that I must have SQL 2000 before I can experiment the conversion.Am I correct? Thanks

Hi All, Can somebody who has SQL 2000 assist with this? Create a simple DTS package using any table from Northwind DB and then prompt the number of rows in that table through a message box. This package should then be posted to me. Aim: I want to experiment conversion of DTS to SSIS 2008 package but I don't have SQL 2000 I look forward to your response. Regards, Current

Hi, After processing your ETL package which loads data into the cube, how do you ensure that your cube has been processed? Current

Hi Niladri, Your answer and that of Blue_boy have really expanded my thoughts.First I am very grateful. Meanwhile, the results from the two queries are different. The problem lies in the filtering. Sincerely, I am really grateful.I will work further on your posted queries. Regards, Current

Thanks a million Blue_Boy. It is good there is an exceptional person like you. Some have no clues, only to be throwing DIATRIBES. Thanks a million Blue_Boy for sharing your knowledge. Regards

modified on Monday, July 18, 2011 4:08 AM

May be you allow others to contribute if you can't soften your words a bit,You footnote speaks for you! cheers

Thanks. Your propositions have been tested without success. Since the sample data is given, if can supply full query, there is no sin! Cheers

Hi Blue_Boy, Did you see my addendum?CompanySize is the number of employees. Cheers

Please can anyone assist me with the following questions? 1. Given the following table (the data could be hundreds of rows): CompanyID CompanyName Town Country CompanySize 1 CompanyA Maryland USA 10 2 CompanyB Maryland USA 19 3 CompanyC Maryland USA 20 4 CompanyD Texas USA 13 5 CompanyE Texas USA 40 6 CompanyE Florida USA 4 For those towns which have more than one company in them, calculate (in one query): · The total number of employees in the town. · The average number of employees in a company (per town). · The average number of employees in a company (per town) only for companies which have less than 20 employees. The results should exclude Florida and be sorted in descending order of the total number of employees in the town. I will be very grateful for your professional response. Regards, Current Addendum I forgot to mention that CompanySize is the number of employees Thanks for your observation.

modified on Saturday, June 25, 2011 7:20 AM