Attribute Level Validation

Valid and Unique Attribute Names

Attribute names cannot be blank, contain any spaces, or use any reserved names. Each attribute in a repository must have a unique name.

If you provide the same name to two attributes, you will get a validation error. Attribute Name can not contain invalid characters.

It allows only alphanumeric character and _ characters and are case insensitive. It should contain less than 30 characters.

Attribute Reserved Names

Some of reserved names are "STATE","MODVERSION","MODDATE", "MODMEMBERID", "CATALOGVERSIONNUMBER","CHECKSUM","PRODUCTKEYID", "LASTIMPORTTIME","ACTIVE","ENDEFFECTIVEDATE","CATALOGID", "BATCHID","PROCESSLOGID","CREATIONDATE","LASTCONFIRMEDVERSION", "OWNERID","OWNERTYPE","PARENTVERSION"

Attribute Positions

If there is one attribute where the attribute property position is set to a valid non-null value then all of the attribute must have the attribute property set to a valid value.

Attribute Column Positions

The column position for a attribute cannot be negative or zero. Define a positive number as column position.

Attribute Column Name

Column name for attribute should contain less than 28 characters.

Column name for Multi- Value attributes should be less than 26 characters.

Column Name for attributes can not contain invalid characters and white space. It allows only alphanumeric character and $#_ characters.

String Attribute Length

Length for attributes of type string cannot be negative (smaller than zero) or more than 4000 characters.

Attribute Group Name

Attribute Group Names cannot contain spaces. Attribute group name should contain less than or equal to 30 characters.

Effective Date Attribute

There cannot be more than one attribute as Effective date. The Effective date must of “TIMESTAMP” type.

Input Map

Input Map name in repository cannot be Undefined.

Input Map should have at least one common column in Input Map for joining Data Source.

Input Map cannot contain spaces.

Input Map name and description cannot contain more than 80 characters.

Input Map descriptions cannot be blank.