Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the fact table like this
Table Orders
Things like Order type or Customer type is stored in one table Parameter, by Category and in different language as following
I would like to obtain the description (label) in the interface according to the application language (via a variable)
like
As far as I see:
- ApplyMap is quick, but it will increase the size of my fact table
- LOAD table Parameter and create link to the fact table, I have more than 10 fields that I would like to extract the description !
What is the best practice to handle such situation ?
Thank you