August 23, 2007 at 7:51 am
hi all:
am not sure that this is the right place to post my question but i didnt find more appropriate place than this ...so excuse me if i was wrong
am searching for a tools that can help building data warehouse faster than the traditional way ,i have been searching for a long time and the only thing i have found is "ORACLE warehouse builder" every were and am sure that there should be s.th like this to use in sql server , so please if any one know any thing about it tel me .
..>>..
MobashA
August 24, 2007 at 10:52 am
I think what you're looking for is Analysis Services, included in SQL Server. You still need to design / build your database, but that's a relatively simple step. (Data warehouses are fundamentally very similair).
SSIS (Integration Services) is a fast way to actually load the data. In particular, focus on the slowing changing dimension tasks, since they allow you to incrementally up-date the tables. A useful capabilty.
October 11, 2007 at 10:58 am
Are you looking for a tool to build data warehouse or report or ETL process?
Data warehouse includes a lot of things.
October 23, 2007 at 3:56 am
what i meant like this, this tool should do the following:
1-create the database for the data WH.
2-ETL procedures.
3-job to transfair the data from the source to the WH.
..>>..
MobashA
October 23, 2007 at 8:45 am
There are a lot of BI tools for example Hyperion (Oracle bought it a few months ago), Cognos, Business Objects (SAP was talking to buy it.) and many others.
October 23, 2007 at 2:35 pm
but would it create the WH design like a snowflack structure or star.
..>>..
MobashA
October 23, 2007 at 5:29 pm
Each one has its own special structure. You have to talk to the company to find it out.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply