Skip to Content
3
Former Member
Sep 07, 2013 at 07:44 AM

Why is Key Attribute mandatory in Attribute View?

658 Views

I am curious about the behavior of key attributes in attribute views.

First I thought it is kind of primary key for the entity Attribute View but then I did a few checks

Created two tables

1. CUST -Customer Table- It has Customer ID and Country ID

2. CTRY -Country Table- It has Country ID and Country Description

An Attribute View on top of these two tables

Simple, nothing complex

Now in Semantics

I am able to activate the attribute view and see the output

but what I do next is interesting..I made the CID as a Key Attribute, though it is not a key in the data ('in' for two rows)

But I am still able to activate the Attribute View and see the data as well. I would like everyone to try this out.

So what I don't understand is if this is allowed why is Key Attribute Mandatory?

I mean why should there be a key attribute if it does not check for Unique Constraint.

Attachments

KeyAttributes1.JPG (20.5 kB)
KeyAttributes2.JPG (35.3 kB)
KeyAttributes3.JPG (19.6 kB)
KeyAttributes4.JPG (24.8 kB)