How can I avoid default join of 2 facts with same field Names and sharing common dimensions?

[#1]

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

[kavita25]

Hi,

Try the below link approaches...

*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****

Hope it helps u...