Saturday, March 26, 2016

Implicit Attribute

============================================================================
An implicit attribute is a "constant" attribute, i.e. its expression is a constant value and therefore not actually saved in a column in the physical table. In order to define an implicit attribute, you need to specify an implicit expression; instead of assigning column names, you specify the constants instead. (e.g. Your attribute form expression could be just 1 or "Y" or 0 or "N" or some such depending on your requirement).
============================================================================
Implicit attribute is a constant attribute. It can be considered as  a "virtual" column in the table.

Use: 
1. Some attribute definitions can be implied by the existence of a row in a

certain table, rather than being defined in terms of  columns. In many applications, such attributes would require dummy columns or views in the database.
Implicit attributes provide a simple alternative that does not require any modification at the database level.
 

2. Another use of Implicit attributes is to use them as counter.

I hope this helps...
=====================================================================================
An implicit attribute is something where it does not physically point to any column in a table its just like a virtual attribute.

ApplySimple("ROW_NUMBER() over(partition by max(1) order by max(1))")

For example you can use the above syntax for creating an attribute to generate runningsum. Here it does not point to any of the column in the database but its just a virtual expression.

============================================================================

No comments:

Post a Comment