datamart
Do we have to use fact table for reports?
开发者_如何学PythonI am working on building a data mart for reporting purpose. I am new to this field and looking for help.[详细]
2023-03-15 19:05 分类:问答Business Reporting on an OLTP Application
We have an OLTP application using Oracle Database 10g Enterprise Edition, and plan to build a bu开发者_JAVA百科siness reporting layer to meet the following needs.[详细]
2023-02-09 20:48 分类:问答Best way to build a DataMart from multiple external systems?
I\'m in the planning stages of building a SQL Server DataMart for mail/e开发者_开发问答mail/SMS contact info and history.Each piece of data is located in a different external system.Because of this, e[详细]
2023-01-19 12:45 分类:问答Is this a proper idea of BI workflow?
I am new to Business Intelligence. I just got hired by a company in order to complete their websolution, implementing a BI Module. After lot of reading, I think I could get an idea of what a BI Proce[详细]
2023-01-16 05:53 分类:问答Does a lot of repeated sum(x) in different cols make a Select slower?
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[详细]
2023-01-11 23:00 分类:问答Suggestions for creating an in-house marketing campaign database in a Microsoft environment?
I\'d like to create an in-house solution to store marketing segment, list, campaign, and communication data.Right now nothing is centralized/standardized.Data is located on a variety of SQL servers, A[详细]
2023-01-08 18:51 分类:问答How do you verify the correct data is in a data mart?
I\'m working on a data warehouse and I\'m trying to figure out how to best verify that data from our data cleansing (normalized) database makes it into our data marts correctly.I\'ve done some searche[详细]
2022-12-22 06:59 分类:问答