Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create fact table using dimension tables

i have created QVD files ( Dimensions Tables )

as i try to use to create fact tables so itself it creates synthetic key instead of mine

what i want to do is

1)   dimension table User

userid key

name

address

2) dimension  Table Target

targetid key

targetname

area

email

3) fact table

userid

targetid


how to achieve this

1 Reply
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Duplicate discussion here: create fact table