data-warehouse
Data warehousing and loading data by using ssis package
I am new to Data warehousing design, I have cr开发者_StackOverfloweated a data warehouse design as of my knowledge.[详细]
2023-03-17 14:52 分类:问答How to capture table level data changes in SQL Server 2008 R2?
I have high volume of data normalized into more than 100 tables. There are multiple applications which change underlying data in those tables and I want to raise events on those changes. Possible opti[详细]
2023-03-15 14:19 分类:问答Database design: how to investigate raw data and model it into an existing database?
As a database developers, what is the best way to investigate new raw data for database when you have to model this data into an开发者_如何学编程 existing database? I mean a situation where you get ra[详细]
2023-03-14 11:17 分类:问答Assessing and comparing Hadoop for Business Intelligence Design considerations
I am considering various tec开发者_运维问答hnologies for data warehousing and business intelligence, and have come upon this radical tool called Hadoop. Hadoop doesn\'t seem to be exactly built for BI[详细]
2023-03-14 00:47 分类:问答Corrupted database table with invalid query: what has it done and will it roll back?
I made the error of running what should have been a quick update against my fact table (200M rows) with this:[详细]
2023-03-13 18:27 分类:问答Best practice to Load Fact table in MS SSIS
I am new to SSIS in data warehouse. I am using Microsoft business intelligence studio. I have 5 Dimensions each having some PK.[详细]
2023-03-12 17:35 分类:问答Accommodating Dynamic Hierarchies in a Data Warehouse Model
I am building a data warehouse for the company\'s (which I am working for) core ERP application, for a particular client.[详细]
2023-03-12 11:12 分类:问答Faceted Search without duplication of data (no ETL)
All solutions I\'ve seen so far involve duplication of data by using nosql or datawarehousing. Are there more efficient ways?[详细]
2023-03-11 17:33 分类:问答Efficient datawarehousing algorithm for counting Rolling Quarter value
Consider a dataset with 6 month data as follows: // Month-01 = 1 // Month-02 = 5 // Month-03 = 3 // Month-04开发者_StackOverflow中文版 = 2[详细]
2023-03-11 08:51 分类:问答Implementing data cube in c#
I am trying to implement a multi dimensional data cube in c#. Could somebody point in the direction of resources that would serve as a starting poi开发者_如何学Pythonnt. I am primarily interested in d[详细]
2023-03-10 19:12 分类:问答