458 reputation
1823
bio website
location
age
visits member for 2 years, 6 months
seen Jul 6 at 3:49

My friends call me "Mac". I'm a master of improvisation. I have vast scientific knowledge and unique abilities to use ordinary objects to get myself and friends out of trouble. I typically carry my Swiss Army knife and a roll of duct tape with me at all times. I dislike guns because of a traumatic childhood incident. I try to avoid violence whenever possible. Because my life was getting too stressful at the Phoenix Foundation, I have picked up programming as a new career. I spend my spare time on Stack Overflow.


Jul
7
awarded  Popular Question
Jul
4
awarded  Notable Question
Jul
2
awarded  Curious
Jun
27
accepted Netezza LIKE operator not finding subsequent backslashes
Jun
27
answered Netezza LIKE operator not finding subsequent backslashes
Jun
25
revised Netezza LIKE operator not finding subsequent backslashes
added 10 characters in body
Jun
25
asked Netezza LIKE operator not finding subsequent backslashes
Jun
23
awarded  Popular Question
Jun
18
answered How to resolve red invalid icon for Informatica mapping
May
21
awarded  Notable Question
May
19
awarded  Popular Question
Feb
28
awarded  Notable Question
Feb
1
awarded  Popular Question
Jan
30
comment How to resolve red invalid icon for Informatica mapping
This was due to an incomplete mapping because my expression transformation didn't have output ports (only input ports) just before the target definition.
Jan
30
asked How to resolve red invalid icon for Informatica mapping
Jan
8
awarded  Yearling
Dec
21
comment Proper implementation of child (derived) table PK/FK during single and multiple inheritance hard coded generalization physical data model
I went with 1b and 2b because it's consistent and because I realized I wanted an identity column for each table so I could easily count the records. If the derived table mirrored the base table, the PK of the derived tables would look goofy. That identity column doesn't necessarily have to be the PK. If there is a composite PK (with more than one column making it unique) and also being a derived table, I kept the identity column as an ordinary column and not as part of the PK.
Dec
16
asked Proper implementation of child (derived) table PK/FK during single and multiple inheritance hard coded generalization physical data model
Dec
13
comment Equivalents to `ora_rowscn` in other databases?
Here is the MySQL equivalent. stackoverflow.com/questions/1364051/…
Nov
28
awarded  Famous Question