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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Aggregate navigators & aggregate tables

Status
Not open for further replies.
monsky

monsky

Programmer
Jul 3, 2002
89
AP
Has anyone tried using aggregate navigators on their data warehouses?

Can you give me a rough figure on how many aggregate tables have you got in your data warehouses?
 
Sort by date Sort by votes
I have over 50 aggregates in one of my warehouse implementation. It realy depends on the reporting needs and also resources (disk space, load window etc.)

I hope this helps.

Anand
 
Upvote 0 Downvote
So do you have an aggregate navigator to these aggregate tables whenever you perform drill-throughs in your application?
 
Upvote 0 Downvote
Hi

can any one be able to assist me in providing some basic info about the ETL tools.

does the ETL tools use the standard SQL commands to extarct , transform and load the data into the warehouse or does this ETL language differ from vendor to vendor ?

I would greatly appreciate anybody who can provide me with this info as i had been BURNING my head with this Q .

thanks
Pat
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sakhi01
  • Locked
  • Question
External Tables in Oracle vs Sqlloader
Replies
1
Views
96
johnherman
johnherman
prgmrcr
  • Locked
  • Question
SCD 2 and fact tables.
Replies
5
Views
162
RiverGuy
RiverGuy
Zeus80
  • Locked
  • Question
DWH: Distinct aggregate
Replies
2
Views
26
Zeus80
Zeus80
tshad
  • Locked
  • Question
Multiple Sources for dimension tables
Replies
8
Views
238
tshad
tshad
A3083131a
  • Locked
  • Question
22 tables about "Codes"
Replies
6
Views
98
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top