i am reading about the \"entity attribute value model\" which sort of reminds me of an star-schema which you use in data warehousing.
we have intra-day Data Warehouse loads through the day (using SSIS, SQL Server 2005). The reporting is done through Business Objects (XI 3.1 WebI).
I have been trying (and failing) to create a new workspace in Oracle Warehouse Builder using the Repository Assistant gui and documentation. After getting past the 10 configuration screens, the gui sh
I am new in designing a ETL process. Currently I have two database, one is the live database where the application use it for every day transaction. The other one is the data warehouse.
I\'m going to be running a large number of simulations producing a large amount of data that needs to be stored and accessed again later. Output data from my simulation program is written to text file
I\'m trying to fine tune a query and would like some feedback. I have a job_fact warehouse table with an unit of measure for the job\'s final event (final_event_type). I\'m trying to run a query on th
How to best store user data vs date/time dimension? Usecase is I am trying to store user actions per day, per hour. Such as number of Shares, likes, friends etc. I have a time table and a date table.
I am designing a data warehouse and I have a sticky issue with time. The grain I need is hourly (to calculate aggregate counts of events per hour) and I also have to accommodate a shift pattern that d
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
I have an Ab-Initio plan consisting of more than one graphs in it. If the plan failed in one particular graph dur开发者_JAVA技巧ing its 6th phase, then how can the plan be restarted from the particula
加载中,请稍侯......