Query items defined in the derivation of the source file
Posted: Tue Aug 02, 2005 11:55 am
hi,
i have a sql query which i defined in the source file and i am taking the data through that query. Where as i also defined the column names in the column section of the source file. Beside the column name there is a derivation column. I am just confused what i have to write there. For eg: there is a calculated column in the query like sum(z*b) as test, so do i have to define the same formula in the derivation like sum(z*b) and column name test.
thanks
shivan
i have a sql query which i defined in the source file and i am taking the data through that query. Where as i also defined the column names in the column section of the source file. Beside the column name there is a derivation column. I am just confused what i have to write there. For eg: there is a calculated column in the query like sum(z*b) as test, so do i have to define the same formula in the derivation like sum(z*b) and column name test.
thanks
shivan