Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Count with Oracle Warehouse Builder

Status
Not open for further replies.
zephan

zephan

Programmer
Jan 14, 2002
217
A2
Hi All,
When I use count function in an aggregator (OWB 9i), the expression type is set by default to the counted item. Ie if I use count(some_date) the type is set to date and grayed (you cannot change it). How could I fix this. Also, I need to be able to count distinct values, I know I can use Dedup operator but to have the clause DISTINCT in the count would be great, any workaround.
Regards,
Zephan
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
698
carp
carp
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
247
TheLazyPig
TheLazyPig
KeyserSoze
  • Locked
  • Question
TOAD for Oracle - Icons
Replies
1
Views
286
Andrzejek
Andrzejek
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
760
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
847
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top