Tagged Questions
3
votes
1answer
73 views
Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
Suppose I have a "main" table that was probably heavily normalized and consists largely of columns that merely contain codes that are lookups into other tables (they are probably foreign keys but feel ...
7
votes
3answers
972 views
When should indexes be dropped and recreated?
We are constructing a data warehouse that initially will be 1 TB and will grow around 20gigs every month.
For certain tables we are doing daily ETL processes and others we are doing weekly/monthly.
...
-7
votes
3answers
188 views
Business Intelligence = Technical OR Business Project? [closed]
Do you consider a project of Business Intelligence to be a technical or business project?
2
votes
1answer
196 views
Review Technical ETL process for knowledge management
I'm looking for source code and all related component/material to review technical ETL process between source database and Data Warehouse in order to increase my knowledge in technical Business ...
1
vote
0answers
23 views
Monoblock, Multiblock queries?
What exactly mean the terms monoblock / multiblock queries in data warehouses when talking about materialized views? Does a monoblock query just use one data source (a normal table) while a multiblock ...
5
votes
1answer
236 views
DBA's Scope in datawarehousing Projects
As a DBA trainee, what needs to be known in order to be part of datawarehousing projects?
I mean what resources are suggested to have an overview knowledge of how PL/SQL and other concepts are used ...
