Cognos based Real Time DW

[astra1]

Hi,

We are in the process of creating a new Data Warehouse on SQL Server and Cognos Suite 7. The DW has to be Real Time with the least possible performance issues. What i want to know is:

1. Can Cognos support Real Time DW ETL by DS or is DTS is the better option (Data Size is 100GB)?
2. What are the features of a modern DW?

Regards,

Vish

 

[DSWork]

Hi Astra1,

Did you ever resolve your issue, if so, it would be interesting to know the result.