Re: ODS and Star-Query

In article <01bd362f$18887200$9317fa35@waila45>, Christoph Kuenzle <christoph.kuenzle@adi.ch> writes >We are planning to build a data warehouse with Informix Online Dynamic >Server 7.24 using extended parallel option and advanced decision support >option. > Can you combine these, I was under the impression you must choose only one option. >Three Questions: > 1. Does Informix ODS 7.2x support star queries? What are they? Give us an example.. > 2. What problems do I have to expect running star queries, > except from full table scans, > which are inevitable in a DWH environment, as I learned. > 3. Are we the only ones trying to run star queries with Informix ODS? > >Thanks >-- >Christoph Kuenzle >ATAG debis Informatik AG >4900 Langenthal >Switzerland > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care