I have the fact table like this
Table Orders
| Order_ID | OrderType_ID | CustomerType_ID | Remark_ID |
| 1 | Exp | B2C | X |
| 2 | Imp | B2C | Y |
| 3 | Exp | B2B | Z |
Things like Order type or Customer type is stored in one table Parameter, by Category and in different language as following
| Category | Language | Param_ID | Description |
| OrderType | D | Exp | Exporthandel |
| OrderType | E | Exp | Export |
| OrderType | F | Exp | Exportation |
| CustomerType | E | B2C | Private |
| CustomerType | F | B2C | Privée |
I would like to obtain the description (label) in the interface according to the application language (via a variable)
like
| (English) |
| Order_ID | Order_Type | Customer_Type | Remark_ID |
| 1 | Export | Private | X |
| 2 | Import | Private | Y |
| 3 | Export | Business | Z |
| (French) |
| Order_ID | Order_Type | Customer_Type | Remark_ID |
| 1 | Exportation | Privée | X |
| 2 | Importation | Privée | Y |
| 3 | Exportation | Entreprise | Z |
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
