Skip to Content
0

Convert technical field names into Business Names

Nov 23, 2016 at 05:15 AM

63

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Andrey Surinov
Nov 23, 2016 at 06:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded