...Hey, I knew a Michael Weiss in college...

Well, I created my view from my existing data where the unique ID is included in the view and since each final DID...

sorry about the dupe..

I have done something similar, but instead of using separate table information, I create a view of the data. For instance:

create view dim_numbers

select

left(variable,3),

substring(variable,4,3),

right(variable,4),

variable,

from datasource

NPA->NXX->DID

You can use...

quote:

---

I am planning a data mart that will have three dimensions I want to combine into a single dimension (ideally without using...