Hello!

I am in process of creating a datawarehouse- for data related to
membership management. I have two tables say- Lead (who will be
converted into members) and Consultant who track these leads and these
are linked by means of a key. Now the lead data may change frequently
with respect to address, contact numbers etc. The consultant may
change his wage rate or may leave the job(inactivated). The leads may
be assigned to different consultants with the passage of time.

So I plan to append the changed data in my ware house table with a
timestamp.

I want to generate a report for how many leads are assigned to a
consultant??

Now the problem I am facing is how to create keys for such tables?

How should I build a cube with a time column so that it will consider
the most recent data as per the time consideration? How should I
prevent hte information from being misunderstood since multiple
entries for the leads will be available?

I am seriously not getting a clear picture!!!

Would someone please help?


--
Gayatri Palkar
SLS Software Pvt. Ltd.


Posted via http://dbforums.com