cbrammer1219 (6/17/2014)
Just curious could I create a lookup table with all the extension in it and then insert that into the CallTrace table where the extension and do the same for the Customer table, because right now there are no PK, FK, it is the worst DB structure I have ever worked with, and yet they want miracles; After this I am going to insist on taking the time to work with my peer to begin creating a datamart, any suggestion for a beginning SQL to accomplish this?
Welcome to the real world, and mind you it is not going to get better, when ever you think you've seen the worst, it gets worse. That's the business and one better get used to it.
I'm trying to find specs on the format, MiTel isn't to common any more, will let you know.
You shouldn't need an extension table unless you can relate/tie the extension to a business entity/value. But if so, in a data-mart/dw feeding into a cube, that would probably become a dimension.
The sql part is tertiary, first business requirements then data models. Only after those steps one starts talking sql.
😎