Search results for query: *

Hello, I am getting a wrong answer (lesser amount) after aggregation. The sum(quantity) in prod_fact_table is 2,089,033 but if I run the insert statement below the sum(quantity) in agg01_agg01_prod_fact_table will be 1,689,785 which is less. The two must be the same. Please what can be the...

Hello, I am new to DB2 and wanted to truncate a time like '2008-08-10 15:04:08' so that I will get a result like '2008-08-10 00:00:00'. What I want to do is to get the beginning of each day. I tried the following query but always get an error: SELECT TRUNC_TIMESTAMP(CURRENT TIMESTAMP - 24...

Hello, I have two dimensions, time and machine. The machine dimension has two levels, machine number and machine location. I have two measures, unit (measures the quantity of machine production) and average_unit. In the machine table of the database there are multiple entries of the machines...

Hello, I have a fact table which has a column called TimeDiff and will contain the time difference b/w the two adjacent rows in another column called TimeCol. Assume TimeCol has the following entries: TimeCol 2002-09-05 14:12:00 2002-09-05 14:12:05 2002-09-05 14:12:09 2002-09-05 14:12:45 Then...

Hello, I am still working on my first trial Data Warehouse. In the Time dimension, I planned to cover data from 01.01.2006 till date on hourly basis and I have the following levels; Year, Month, Quarter, Week, Day, Hour, Holiday_Flag. My question is how do I at best achieve that - populating...

Hello, I am a newbie in datawarehousing and gradually working hard to understand how to implement it. Assume one of my dimesion table is called Location which has the following columns: Location_id, Country, State, District, Town. My question is if I want to populate the above table will each...