ssas - Data Warehouse - Multidimensional Model - Fact Table is Smaller than Dimension Table -


i working on data warehouse project customer dimension table larger fact table. dimension , fact tables created crm system.

the fact table monitors activities such letter sent customer or customer calls assistance. half of customers have no activities , remaining customers have few activities; of customers have activities have single activity.

i not sure if star schema best solution project. have worked on similar projects & solution.

if many of dimension members not related facts @ all. sugest filter unused dimension members during etl process.

so a

     select customer_id, name dil.customers         customer_id in         (select customer_id dil.calls)

-

Comments

Post a Comment

Popular posts from this blog

android - Automated my builds -

i have multiple app , android project want automated in build , release sequence. have ant script build , create apk of app. want have 1 script or ant file start build sequence app. maybe don't konw search, can't find easy documentation on ant. the point of use jenkins ant (or maven, i'm not sure of difference between them now) automated build sequence when people commit on project. any int appreciated maven dependencies (over ant) don't need pass around jars. recommend maven on ant day. syntax , overall process easier understand, @ end of both build tools. if able to, more recommend upgrading gradle. easy create different build types , create them ./gradlew assemble here project jake wharton can see power of gradle. there release , debug build, can make lot more if like. https://github.com/jakewharton/u2020 here android docs gradle http://tools.android.com/tech-docs/new-build-system/user-guide . if can't find looking here, check out main grad...
Read more

python - How to return the most similar word from a list of words? -

how create function returns similar word list of words, if word not same? the function should have 2 inputs: 1 word , other list. function should return word similar word. lst = ['apple','app','banana store','pear','beer'] func('apple inc.',lst) >>'apple' func('banana',lst) >>'banana store' from doing research, seems have use concepts of fuzzy string matching, nltk, , levenshtein-distance, i'm having hard time trying implement in creating function this. i should point out similar, mean characters , i'm not concerned meaning of word @ all. slow solution debugging: def func(word, lst): items = sorted((dist(word, w), w) w in lst) # print items here debugging. if not items: raise valueerror('list of words empty.') return items[0][1] or, faster , uses less memory: def func(word, lst): return min((dist(word, w), w) w in lst)[1] see https://stackover...
Read more

apache - GeoServer under https -

i using apache web server on localhost:80 , geoserver served tomcat on localhost:8080 i installed ssl certificate on apache , works fine except message says have insecure content thought geoserver layers. i'm trying enable ssl geoserver , have openlayers content htis https://example.org:8080/geoserver still not sure what's best approach that.
Read more