dennisf at 23h52
07
Aug
2009
Language translation for large number of codes
The significant dimension tables in our data model each contain 25 or so codes. Example currency code, category code
etc. Each of these dimension tables have different sets of codes i.e they do not share identical sets of codes. Each
code requires a short and long description for each supported language. The descriptions do not change frequently.
One model would be to store the three attribu
The significant dimension tables in our data model each contain 25 or so codes. Example currency code, category code
etc. Each of these dimension tables have different sets of codes i.e they do not share identical sets of codes. Each
code requires a short and long description for each supported language. The descriptions do not change frequently.
One model would be to store the three attribu
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
Ten(10) or so key dimensions(lets call them base dimensions) each has about 25 parent code tables in the 3rd normal operational source. Each code has a short and long description. In the multidimensional model If a fact table has say 3 base dimensions the
Hi all.
I have a dimension with 35+ million records as compared to 225 Million in the fact table. I am not sure about the kind of penalty we will have to pay for such a big dimension. Here is summary regarding this dimension.
This dimension is derive
I am loading a Star Schema from a data base that acts as the staging area. We are converting our source systems to a new transaction system. We are converting data to the new transaction systems in large chunks with conversion dates spread over 3 years.
We have a traditional dimensional model and are about to add multiple languages to our source systems and need the option of reporting certain dimensional attributes in either the local language or English. Has anyone developed a flexible model for this
I came here with The Seldom Seen Kid under my arm and it wasn't long before the great and the good here were recommending I try out eariler works by the band. My wife recently bought me Leaders Of The Free World and Cast Of Thousands and I've been slowly
Forums from same category
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Search
Informations
4 Replies For the topic :
"Language translation for large number of codes"
This topic has been viewed 1853 times.
Last message :
07/08/2009 at 23h52 by "dennisf"






