Print Page - Derivation in data stream or in select statement?

Title: Derivation in data stream or in select statement?
Post by: Nico1984 on 06 Jul 2007 02:53:25 AM

Could somebody explain me the difference in performance between a derivation in the datastream and a derivation, written in SQL, in the select statement?

Thanks

Title: Re: Derivation in data stream or in select statement?
Post by: Blue on 06 Jul 2007 10:23:51 AM

As I understand it the former is done by the Data Manager tool AFTER the data has been read from the database and the latter is done at the database and read by Data Manager as database metadata.

Bluey

COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: Nico1984 on 06 Jul 2007 02:53:25 AM