I have two entities, each with an attribute ‘DBID’ (a per-row unique ID) in a logical data model.
These two entities have a one-to-one relationship between them.
When I use the ‘Simple Model Conversion’ feature to create a physical data model (for a particular database) - then the corresponding entities in the new physical data model have TWO copies of the DBID attribute (which obviously causes problems when you go to generate DDL and load into the database).
I would have thought that as part of the specification of the relation (in the logical data model) - I could control the name of the synthesized attributes in the physical data model, but I failed to find anything like that.
Please also note - that the ‘Validate’ function on the logical data model reported no issues.
Note - I also looked at the more general ‘Model Conversion’ UI, and I didn’t see anyplace there either.