Skip to Content
avatar image
Former Member

data movement model- showing code translation

I need to represent a simple conversion of an incoming coded column to an outgoing one in the data movement model. I tried using script execution but am not sure how to do it. For example input = columnA, output columnB. In SQL I'd do something like CASE when ColumnA = 1 then 'X', when ColumnA = 2 then 'Y', when ColumnA = 3 then 'Z'.

Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 15, 2017 at 11:44 AM

    It's really looking for the method you'd use to translate the values of one column into another column. If I was to code it I'd use a mapping table or a case statement in SQL. I'm really looking how to do this in Powerdesigner. I thought a script execution looked the most appropriate but couldn't find a way to do it.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks George. Yes, I do agree, there is so little documentation that's a useful "how-to" on data movement modelling. I'll try a few scenarios out and see what works best.

  • Sep 15, 2017 at 09:32 AM

    I'm not an expert on Data Movement Models, but I have an insatiable curiosity for all things PowerDesigner, so I'm trying to understand your question - perhaps someone else may be able to pin down the final answer.

    For clarification - is it the script in the Script Execution object you're asking about, or how to limit the columns that are input or ouput to the Data Transformation Task?

    Add comment
    10|10000 characters needed characters exceeded