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 still want to get it right. Assume my Sales Dimension table is: sales_key smallint not null, sales_id smallint not null, sales_date date not null, product_id smallint not null, sold_by varchar(200) not null The above table is populated with the following: 1,4,2007-07-01,36,Marley...

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 MDXer, You said and I quote "Each row should have a different Surrogate Key". So, do you mean that each row in a dimension table should have different surrogate key or do you mean in the fact table? If each row in a dimension table should have a different surrogate key then how do we...

Hello, I think I was able to figure-out the solution. I previously wanted to know if when populating a dimension table if all the rows will have the same surrogate key which is yes.

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...