Home » Developer & Programmer » Warehouse Builder » Queries Regarding Oracle Ware House Builder  () 1 Vote
Queries Regarding Oracle Ware House Builder [message #93226] Thu, 08 January 2004 18:40 Go to next message
Vidyanand More
Messages: 35
Registered: January 2003
Member
Hi All,
Environment Details is as follows:
OWB : 9.2
Oracle 9.2.0.1
My queries are as follows:

1> I need to select record from a table as follows:
select count(*) from emp, for this i am using aggregator operator, however i found that OWB doesn't provide function to count(*). I am wondering how this can be acheived in OWB?

2> Is there any way OWB can refer to environment variables?

Can someone please provide more information?

Thanks in Advance.
Regards,
Vidyanand
Re: Queries Regarding Oracle Ware House Builder [message #266585 is a reply to message #93226] Tue, 11 September 2007 03:22 Go to previous message
mustang114
Messages: 1
Registered: September 2007
Junior Member
Use the aggregator operator, in the ingrp select the column which you need to count and in the outgrp specify the group condition as count.
I Think this will work.

Regards
Elavarashan
Previous Topic: External table in OWB
Next Topic: rtc error 5260 and 5301
Goto Forum:
  


Current Time: Tue Jul 29 22:31:43 CDT 2014

Total time taken to generate the page: 0.10057 seconds