Question : I have a general question on a Data Warehouse Architecture. I have heard a lot of a Staging […]
Tag: data-warehouse
Limit the degree of parallelism (DOP) available to any query
Question : On Oracle Exadata (11gR2), we have a relatively beefy database. cpu_count is 24 parallel_server_instances is 2 parallel_threads_per_cpu is […]
Do I need to enumerate the columns used in a materialized view when creating the MV log?
Question : I’m currently creating materialized view logs on a whole bunch of tables in order to support materialized views […]
Using On-Premise SQL Data Warehouse Data for OLTP applications
Question : Quick Information: Our EDW group has created On-Premise SQL Data Warehouse by collecting information from several systems. These […]
How should I build a DB to hold data about another database
Question : I know that this is a strange question. I need ideas and/or advice, not necessarily “how-to”s. I work […]
ETL: extracting from 200 tables – SSIS data flow or custom T-SQL?
Question : Based on my analysis, a complete dimensional model for our data warehouse will require extraction from over 200 […]
ETL Issue failing with Timeout error
Question : We have a ETL job which is running each day at 02:00 AM. Until last week the Job […]
SQL Server: Database integration and synchronization
Question : I have n SQL Server databases with the same data schema. On the other hand i have a […]
Designing an Accumulating Snapshot with Repeated Groups, need advise
Question : Situation I need to create a pie chart that has to be able to be represented at the […]
Data Warehouse design for reporting against data for many time zones
Question : We are trying to optimize a data warehouse design that will support reporting against data for many time […]