Archives of the TeradataForum
Message Posted: Mon, 23 Feb 2004 @ 21:51:01 GMT
Ok.. Got a little brain teaser for the list. I have a way to work it, but it certainly is not efficient.
Customer has 1 or many Products (up to 5 total)
Product has 1 or many account numbers (no limit)
Accounts can have a status of active or cancelled
List by customer, product mix (see below) and status - Active, Cancelled, Mixed (active + cancelled in multiple instances)
Product mix (illustrative)
So, it is necessary to reclassify at the customer level if it qualifies as Active in one product and Mixed or Cancelled in another the status of Mixed overall.
This would work great in a multi-dimensional cube, however I have to process this in SQL.
Any creative suggestions?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|