Data Warehousing Conference

November 2010
M	T	W	T	F	S	S
		Dec »
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30

Archive for November 18th, 2010

5 items.

Data Management & Warehousing Portal – Expertise and Knowledge in Data Warehousing

by on November 18, 2010 at 5:45 am

The Data Management & Warehousing Knowledge Base provides information and techniques about the design, build and implementation of data warehousing solutions that we as a company use and hope that you will also find useful.

↓ Read the rest of this entry…

Oracle’s Top Model (SQL Clause)

by on November 18, 2010 at 5:44 am

Posted In: Ittoolbox

The tinyurl for this posting is: http://tinyurl.com/23p4yj3

The question seemed simple: “I want to [to group] rows [so that] the sum of col1 is

↓ Read the rest of this entry…

SQL MODEL Clause: Charlie and the Chocolate Factory, Not Lucy and Ethyl

by on November 18, 2010 at 5:44 am

Posted In: Ittoolbox

My previous entry gave an example using Oracle’s SQL Model Clause. We’re given the first 2 columns, and want to know how to derive the third; the third column groups values such that “the sum of col1 is


  A       COL1        GRP
--- ---------- ----------
  1         10          1
  2         90          1
  3          1          2
  4          5          2
  5          5          2
  6         50          2
  7         99          3
  8          2          4
  9         10          4
 10         50          4 ↓ Read the rest of this entry...