Derived Columns - Proper Use

Question

Derived Columns - Proper Use

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

This sounds like a reasonable approach.

The way I normaly handle things like this , would be to create a look-up table with all the JType values add a column with the category name.

Then do a look-up transformation (or a join on the datasource query) to match the category name to the Jtype , then add the categoryname as a new column on the data flow.

jeffsmith.or SSC Veteran Points: 262 More actions · Answer 2

Ok, I can see that. Sounds like from your first remark, I don't need to be embarrassed about the way I did it, but the Lookup transform definitely seems like a cleaner, more maintainable solution. Thanks for the improvement.