Home » Developer & Programmer » Data Integration » 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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 04:53:34 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.