Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Wrong answer after aggregating
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... -
Truncating Timestamp
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... -
MDX Query
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... -
How to implement datetime difference
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...- Jony77
- Thread
- Replies: 2
- Forum: Data Warehousing/Big Data
-
Populating Dimension and Fact Tables
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...- Jony77
- Post #6
- Forum: Data Warehousing/Big Data
-
Populating the Time Dimension Table
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...- Jony77
- Thread
- Replies: 3
- Forum: Data Warehousing/Big Data
-
Populating Dimension and Fact Tables
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...- Jony77
- Post #4
- Forum: Data Warehousing/Big Data
-
Populating Dimension and Fact Tables
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.- Jony77
- Post #2
- Forum: Data Warehousing/Big Data
-
Populating Dimension and Fact Tables
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...- Jony77
- Thread
- Replies: 6
- Forum: Data Warehousing/Big Data
