I am working on a data warehouse and looking for an ETL solution that uses Python. I have played with SnapLogic as开发者_JAVA百科 an ETL, but I was wondering if there were any other solutions out ther
I\'m getting started with building a Business Intelligence system using MS technologies. I don\'t have any experience with Integration Services or with Analysis Services, so the learning curve is pret
I have a fact table called Loans.In this table in a loan identifier, the date the loan was made, and the amount of the loan.
I`m new to data warehousing, but I think my question can be relatively easy answered. I built a star schema, with a dimension table \'product\'. This table has a column \'PropertyName\' and a column
In our application, we support user-written plugins. Those plugins generate data of various types (int, float, str, or datetime), and those data are labeled with bunches of meta-data (user, current d
I\'m working for a company running a software product based on a MS SQL database server, and through the years I have developed 20-30 quite advanced reports in PHP, taking data directly from the datab
This fairly unusual, but because of office politics etc. we have (read-only) access to the data warehouse, but not to the live data. However we need up-to-date data to populat开发者_高级运维e our rela
I have a really big table with dozens of columns and lots of rows. Lets call this table FT. Everyday I run a script that reads data from the FT table, perform some calculations, and update a smaller t
I\'m currently building our Data Warehouse, primarily using Ralph Kimball\'s methods and guidance. We are using the Microsoft stack for this (so SSIS, SSAS).
I\'m developing a data warehouse and have come up against a problem I\'m not sure how to fix. The current schema is defined below:
加载中,请稍侯......