dbTalk Databases Forums  

Advantages having Dim/Fact tables in SQL2005 than Informix (for AS2005)

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Advantages having Dim/Fact tables in SQL2005 than Informix (for AS2005) in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Outrun via SQLMonster.com
 
Posts: n/a

Default Advantages having Dim/Fact tables in SQL2005 than Informix (for AS2005) - 10-23-2006 , 02:16 PM






Greetings! We are migrating from AS2000 to AS2005.
When we worked in AS2000, we connected to Informix Database (where there are
the fact tables and dimensionals) with a ODBC driver.
As we are migrating to AS2005, papers said that ODBC is not supported.
The issue is, that the organization want to evaluate that if is better to
migrate the fact and dimensional tables to SQL Server 2005.

Do you know how better is having tables in SQL2005 than in Informix?

You must know that Transactional tables are in Informix, and today, DTS fill
the dimensional and fact tables from Informix-Informix. And AS2000 process
cubes accessing to Informix.

I want some comparisson how is better having this tables in SQL2005 than in
Informix.

--
If sun burns, sand too!

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-olap/200610/1


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.