dimensional modeling - Data Warehouse - Dimension with free text fields -



dimensional modeling - Data Warehouse - Dimension with free text fields -

i after advice on best way model info free text fields. next simplified have factincident table , dimension called dimpropertytype. there 3 fields define propertytype called type1, type2 , type3 , these each contain 1 of possible 20 values. wanted have dimpropertype next fields:

propertytypekey

type1

type2

type3

however looking @ info each set of property type options there alternative titled 'other' , additional set of fields called - type1othertext, type2othertext , type3othertext. have looked through info , 80% of each of fields have been set 'other' respective free text set. speaking business analysts searches utilize these fields constraints need in there somewhere.

does have advice on best way of dealing situation? looking through info issue occurs in number of different dimensions going have deal number of times.

thanks.

data-warehouse dimensional-modeling

Comments

Post a Comment

Popular posts from this blog

c# - ASP.NET MVC Sequence contains no matching element -

c# - ASP.NET MVC Sequence contains no matching element - i new asp.net mvc. have finished project unusual issue appeared in project. as seek run project error message. an exception of type 'system.invalidoperationexception' occurred in entityframework.dll not handled in user code additional information: sequence contains no matching element in 1 of controller using statement below groups display in dropdownlist. http://localhost....../clients (trying run page) , getting error on line containing code below. viewbag.groupdropdownvalues = new selectlist(db.groups.orderby(m => m.groupid), "groupid", "groupname"); or other controller: viewbag.categorydropdownvalues = new selectlist(db.category.orderby(m => m.categoryid), "categoryid", "categoryname"); this happening in controllers using syntax. i need display dropdownlists values database. working correctly till morning. don't have thought changed ,
Read more

java - Parsing XML, skip certain tags -

java - Parsing XML, skip certain tags - i next mkyong's great tutorial on how parse xml in java, have situation need read tags within area. e.g. <?xml version="1.0"?> <company> <staff id="1001"> <firstname>yong</firstname> <lastname>mook kim</lastname> <nickname>mkyong</nickname> <salary>100000</salary> </staff> <staff id="2001"> <firstname>low</firstname> <lastname>yin fong</lastname> <nickname>fong fong</nickname> <salary>200000</salary> </staff> <changes> <staff id="2001"> <firstname>low</firstname> <lastname>yin fong</lastname> <nickname>fong fong</nickname> <old_salary>175000</salary> <ne
Read more

rest - How to invalidate user session on inactivity in a stateless server? -

rest - How to invalidate user session on inactivity in a stateless server? - i'm building stateless restful server backend in java, used angularjs frontend. since should stateless, don't create sessions generate access tokens, more exactly json web tokens, client has nowadays on every request. the tokens contain "expires" field acts absolute expiration date. however, have additional expiration on user inactivity. define access token valid long 24 hours if user active 1 time every 30 minutes. i implement writing database on every request , verify time between requests, seems lot of work working out of box when using application server's session management. to 100% stateless on server side need force state logic client. solution is: issue jwt 2 expiry dates (one session - 30 minutes, sec refresh - 24h) implement getting new token same user previous token (new token has new expiry date session, same refresh) reject requests when whatever expir
Read more