hi i have i am trying to solve synthatic keys but its very difficult to do can any one please crate nice datamodel

[#1]

hi i have  i am trying to solve synthatic keys but its very difficult to do can any one please crate nice datamodel with fact table or master table. i am trying lot,but again some synthatic key is generating please solve this?

[Gysbert_Wassenaar]

Rename some fields using direct renaming and Qualify/UnQualify statements. See attached qvw.