Question:
When Editing UDPs of Type: List in the Bulk Editor, I am able to input an arbitrary value and not choose values from the List. Why does it allow for this functionality?
Answer:
When editing UDPs within erwin Data Modeler, if defined as List type, the values accepted must match the ones in the list. However, this rule is not enforced when adding the input from Bulk Editor.
The purpose of Bulk Editor is to help users make changes in Bulk. Checking the external input by users can be quite daunting in terms of performance. Imagine if you have 1000+ Attributes/Columns in a model and each input needs to be verified against the list; it will take quite some time. Additionally what should be done if a value is not in that list, should that be ignored, the process stopped or create another log to show the discrepancies.
This was never the purpose of the making changes in bulk, either using Bulk Editor or even an API. erwin DM is a design tool and depends a lot on user's input. It is expected of users to enter the data correctly.
Comments
0 comments
Article is closed for comments.