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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Jony77
  • Content: Threads
  • Order by date
  1. Jony77

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

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

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

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

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

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

Part and Inventory Search

Back
Top