Create a "Lock Metadata Import" button that keeps a table's metadata from being accidentally overwritten at source level.

Create a "Lock Metadata Import" button that keeps a table's metadata from being accidentally overwritten at datasource metadata level. This is for ADMM.


The reason for this is that at times database primary keys or datatype definitions create issues for source data import.

For Example:

  • Maximo has no primary keys. You must add primary keys for the working table creation. Updating the system metadata information to specify key fields will enable you to create your working table (source table) correctly.

  • Maximo has timestamp field datatypes that cannot be inserted into. These need to translate into nvarchar so that you can insert data into them in your working table. Working table needs to create field that can be inserted into.

  • Guest
  • Aug 7 2024
  • Attach files