Michael McGowan

224 reputation

214

bio	website
	location	Newark, DE
	age	29
visits	member for	2 years, 2 months
	seen	Mar 6 at 22:45
stats	profile views	12

Contact: firstname dot lastname at gmail dot com

	224 reputation	bio	website		visits	member for	2 years, 2 months
214 badges		location	Newark, DE		seen	Mar 6 at 22:45

summary answers questions tags badges favorites bounties reputation activity

52 Actions

suggestions reviews revisions comments badges posts accepts all

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
May 14	awarded	Popular Question
Jan 25	awarded	Popular Question
Jan 20	accepted	Separate tables or partition one huge table?
Jan 14	asked	Separate tables or partition one huge table?
Jan 11	comment	Can I specify a different disk for a specific MySQL table? This worked my MyISAM tables. It didn't seem to work with InnoDB, but I didn't really expect or need it to.
Jan 11	accepted	Can I specify a different disk for a specific MySQL table?
Jan 10	answered	Can I specify a different disk for a specific MySQL table?
Jan 4	comment	Can I specify a different disk for a specific MySQL table? The `mklink` didn't seem to work with the `/h` option...I'm guessing this is because I'm using 2 different physical disks. I tried removing the `/h` option and thought for a moment that it worked. However, now when I try to query the new table it tells me, "Got error 140 from storage engine."
Jan 4	comment	Can I specify a different disk for a specific MySQL table? I thought the Windows issue was only with respect to MyISAM tables. In the 2nd paragraph I thought you were giving a Windows solution.