Brilliant post title!
Usually if you want it somewhat integrated with standard transformations, you use case statement in SQL (Extract, SQL Join transformations).
But if you have more than 30 conditions, chances are that there are better ways to accomplish your task, i.e. by using some kind of look up table instead. Tell us more about the underlying requirement, then we'll be able to guide you better.
Data never sleeps