Hello Sasidhar, thanks for your reply; however your suggestions doesn't create a relation between the two tables. I mean: selecting a record in "AreeBusiness" does not load any record in "FatturatoInterventi".
Update: actually, loading **both** %Key and %IDTipoBusiness works! It load exactly all the records without duplicating. Thanks @Sasidhar Parupudi for leading me in the right direction! I wouldn't have done it without your help
By the way, I would like someone to enlight me as I've not understood the reason why it would work as normally.
In your case you are "just" creating an association between a fact table "FatturatoInterventi" and the AreeBusiness (dimension table).
And that is even unnecessary as you used the mapping table at first to bring the TipoBusiness field into your fact table with the apply map.
you ended your script by removing the key field between your 2 tables (%IDTipoBusiness)
this explains why when creating a table like you did, you duplicate all of your lines by the number of TipoBusiness values that you have (3) (8226 8227 8232), which is obviously incorrect (as you already knew by yourself with the %TypoBusinessCheck field)