Data Modelling

[agni_gold]

Hi,

I have 10 dimension tables ,

and i already make fact table using these dimension tables ,

but these table are not cross referenced to each other through fact table . how can i do this ,

Please help .

[agni_gold]

Please tell me when i reply this msg how can i attach files in this ?

[agni_gold]

Yes thats i am asking , If same fields are present then QV makes internally synthetic table which contains all common fields and generate a synthetic key ,

my question is that if number of common fields are more then , is these is any way to remove this synthetic table (generated by QV).

[Clever_Anjos]

You can concatenate your fields, generating a unique key

autonumberhash128(Dim1,Dim2,...Dim10) as my_key