Hi All,
I have 2 facts tables and both of them are having same fields name except the measure field.
Both I have to use both facts in same application and should share same dimensions. How can I do this?
Fact Touch On
| EMPKEY | CARDKEY | TOUCH_TYPE | TOUCH_ON_COUNT | DATE_KEY | TIME_KEY | TOUCHMACHINEKEY |
| 1 | 111 | Touch On | 1 | 20150512 | 1203 | 10 |
| 2 | 112 | Touch On | 1 | 20150512 | 1205 | 10 |
Fact Touch Off
| EMPKEY | CARDKEY | TOUCH_TYPE | TOUCH_OFF_COUNT | DATE_KEY | TIME_KEY | TOUCHMACHINEKEY |
| 1 | 111 | Touch Off | 1 | 20150512 | 1629 | 11 |
| 2 | 112 | Touch Off | 1 | 20150512 | 1740 | 12 |
Message was edited by: Shivendoo Kumar
