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 : 1842
- Numbers of messages : 8656
- Numbers of users : 3787
- Numbers of points : 1497
Similar topics
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.
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
Im german and even though I hope that everyone will understand me, there might be difficulties or errors in the translation. I would be very happy, if you can give me indications when you find mistakes on the board settings or anything like that.
Also,
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
Im using a pop out chatbox from a widget tab which is perfect size at the moment in my forum to suit needs of members. However when members post images in the chatbox using [img] tags the images are way too big for my liking and destroy the flow of the
Forums from same category
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
LEGO Island Discussion, modding, news and more!
HmongThoobNtiajTeb. com/
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
Informations
4 Replies For the topic :
"Language translation for large number of codes"
This topic has been viewed 1838 times.
Last message :
07/08/2009 at 23h52 by "dennisf"






