Help on display field and unque field while creating fields for table

[Former Member]

hi..

Can any one tell me what is meant by Display filed (DF) and Unique filed (UF) while creating fields for tables in Repository .what is the difference between them

Regards

Yuga

Edited by: ANAMALAMUDI YUGANDHAR on Jul 13, 2008 11:42 AM

[Former Member · Accepted solution]

Hi,

Please update the thread status if your query has been solved or if you need some more information then kindly let us know.

Regards,

Jitesh Talreja

[Former Member]

Hi,

Display Field:

For better understanding lets classify display fields into two:

Display fields in Lookup table:

If you have created a Lookup field in the main table that is looking into some lookup table then the value of the lookup field will contain the combined values of all the display fields of the lookup table.

E.g. You have lookup field say country which is looking into lookup table countries(Country code, Country Name, Lattitude, Longitude) then

Country - India, IN

United States, US

Australia, AU

Display fields in Main table:

Display fields of main table participate in the relationships i.e. when you export relationships through Data Manager then all the display fields will be available at the output.

Also it is useful in MDM Java APIs i.e. when you display any record then only display fields will be visible in the output.

Unique Field:

The field which is marked as Unique wont allow you to enter the same value i.e. no repetition of values allowed for the field marked as Unique.

Regards,

Jitesh Talreja

[Former Member]

Hi,

i will expalian with an example.

if you are having a table Emp details with fileds as Emp Name,Emp No. Emp add.

if u are having employee address as table with fields as employee house no,emp city ,emp state.

if we are using this table in the empleyee details .the fields whicha re required in th emp detable only keep it as diswplay fields. that means in the emp details tab emp city and em stae is only required the keep those fields as display fields.

unquie field means normally emp No should be unique that menas with sam empo no two records should not be there then we keep emp id as unique.

[Former Member]

Hi Yuga,

Display Field

A display field is a field in a table, which is used to represent the entire record. In a lookup table, for example, in the selection list for the lookup field, the values of all display fields are shown, from which we can select the record we want.

For example, In an address management system, the country could be a lookup field to avoid duplicates and ensure proper spelling. The lookup table Country would contain the abbreviations of the countries, along with their full names.

When a new address is entered , a drop down list appears in the Country field. Whether the abbreviation or the full name is displayed depends on which of those two fields was defined as a display field. The value of the display field also determines the names of nodes in hierarchies or taxonomies.

Note: 1. For each table, there can be multiple display fields defined, if one field alone is not unique or unclear.

2. At least one field must be defined.

3. Special Tables and Object tables have no display fields.

4. For Hierarchies or taxonomies, the automatically generated field Name is a display field, which can not be changed.

Unique Field

If a field is a unique field, then the value entered must be unique in this table. This can also be combination of multiple values. That means that the corresponding value or the corresponding combination of values can occur only once in the table. For example:

A customer number can be assigned only once and should therefore be defined as a unique field. For the banking information, on the other hand, the combination of account number and the bank number must be unique, and not just the individual fields themselves. In this case, the combination of the two fields would be defined as unique.

If not otherwise defined, a unique field does not need to be filled, that is, it can be left empty. The value "empty" (or NULL) is therefore not subject to the uniqueness constraint, since it may occur in multiple records.

Hope it will help you.

Regards

Richa

[Former Member]

Hello

Display Fields are non-technical keys used to uniquely identify each record in a table.

A Display Field for a table is a field whose value is used as:

a)The corresponding lookup field value for each record

b)The node name for the record in hierarchy trees

c)The name of the record in the Product Relationships dialog box.

DF Should be limited to the minimal set of fields that can uniquely identify records in a table.

Unique Fields is a constraint that enforce the uniqueness of each record in a table.

(Unique Field could be defined either on a single field or a combination of fields)

A good way to look at is is for example a countries table.

The Unique field may be the country code which is a two letter code and is the actual unique key of the table.

But when data users want to peek up a country within this picklist of records they do not recorgnize the countries by this code (IL). Rather, they recorgnize it by the Name (Israel) which is more the non-technical unique identifier. Therefore, the UF is the code and the DF is the Name.

Best regards,

Hedda Cohen.