When you configure the Integration Service, you can choose how you want the Integration Service to handle null values in aggregate functions(NULL or zero). By default the Integration services treats null values as Null in Aggregate functions, If you don’t want it to be like that then you can configure to treat null values as Zero.
A blog where you can explore everything about Datawarehouse, OBIEE, Informatica, Power BI, QlikView, Hadoop, Oracle SQL-PLSQL, Cognos and much more....
Friday, 31 August 2012
Null Values in Aggregate Functions
When you configure the Integration Service, you can choose how you want the Integration Service to handle null values in aggregate functions(NULL or zero). By default the Integration services treats null values as Null in Aggregate functions, If you don’t want it to be like that then you can configure to treat null values as Zero.
Subscribe to:
Post Comments (Atom)
Hi,
ReplyDeleteIf you don’t want it to be like that then you can configure to treat null values as Zero.
BUT HOW?