Skip to Content
avatar image
Former Member

Convert technical field names into Business Names

Hi,

I would like to direct this question to all Data Integration/Migration professionals.

I have a requirement wherein I need to replace technical field names within the columns of a table (generated by the DI_ERROR COLUMNS) of the validation transform with their descriptions. The description is a label which is attached to the column within a Query transform. Is this possible in BODS? What are the other workarounds? The strategy that I had in mind was to use the initial invalid table generated as a base and then do a search and replace of the possible technical names within the error columns with the business terms. However, this will restrict the solution to the business terms vocabulary that we have. If someone has a better/refined approach kindly respond. Any help is greatly appreciated-

Thanks,

Abhishek

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 23, 2016 at 06:37 AM

    Why not use "RuleViolation" output (in addition to "Fail" output) which has DI_RULENAME field that you can put business description into.

    Add comment
    10|10000 characters needed characters exceeded