Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I have the following table structure:
Fact tables:
LatexCollection
---------------
Date FieldNo Empno LAT
01/04/2010 1 W001 10
TreesPlanation
--------------
Date FieldNo Tree_Planted Tree_Lost
30/04/2010 1 1000 30
30/05/2010 2 6000 100
Dimension tables:
FieldMaster
-----------
FieldNo Name
1 F2010
2 F2009
Calendar
--------
Date Year Month
01/04/2010 2010 apr
Can anybody suggest how to make relationship among these tables.
regards and thanks
chandan
In the example in the linked thread, the DateType field and set analysis are only required to handle the case where a single key field has more than one date field associated with it, and we want to preserve that information.
I see nothing wrong with your example, but it isn't designed to handle that case.
simpler requirement = simpler solution
Hi John,
Thanks for your reply. I understood clearly by your explaination why my solution won't work when multiple dates are associated with single key field. We have to use date type in link table and set operator to distinguish between two dates.
Thanks,
Anosh