284 reputation
1618
bio website
location Newark, DE
age 31
visits member for 3 years, 7 months
seen Jan 29 at 16:12

Contact: firstname dot lastname at gmail dot com


Sep
24
awarded  Autobiographer
Jul
2
awarded  Curious
Mar
27
awarded  Popular Question
Feb
12
awarded  Notable Question
Jan
22
awarded  Notable Question
Jan
12
awarded  Nice Question
Dec
26
awarded  Famous Question
Jul
8
awarded  Notable Question
Jul
4
awarded  Notable Question
Jan
25
accepted Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
Jan
22
comment Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
Thanks. Is "lookup procedure" the standard name for this operation? I haven't found this exact functionality yet, but my experience is pretty much limited to Talend/Jaspersoft ETL. There this can be faked with their components for joins, but your approach seems more natural if available.
Jan
21
comment Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
@ChrisAldrich If I understand you correctly, it sounds like you propose including the entirety of every lookup table within the view query itself. That raises several concerns, among them that the query string itself might be too big to handle.
Jan
21
comment Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
@ChrisAldrich Maybe I applied the term "data warehouse" incorrectly; I don't know and I'm not a DBA by trade. I'm trying to talk about a generic situation where this main table exists somewhere but we don't want to look at it with those yucky codes. Surely this thing happens all the time, so how is it typically handled?
Jan
21
comment Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
For the moment I'm using MySQL, but I'm hoping it's not database-specific as I wanted a more general solution.
Jan
21
asked Is there a standard way to replace codes with values from a lookup table for reporting or analytics?
Nov
6
awarded  Popular Question
Oct
24
awarded  Popular Question
Aug
27
comment Why does MySQL say I'm out of memory?
@winmutt You may very well be correct, but your comment does not help anyone without further explanation. Could you please help us by giving reasons for your sentiment?
Jun
16
awarded  Yearling
May
15
awarded  Notable Question