idmv_value_basic vs idmv_value_basic_active
I don't know if its an issue or my understanding is wrong.
select attrname,searchvalue from idmv_value_basic_active where mskey = 12345 => fetches me 16 rows
select attrname,searchvalue from idmv_value_basic where mskey = 12345 => fetches me 45 rows
I thought idmv_value_basic and idmv_value_basic_active to fetch me same data for a given user.
I would like to know the difference between the views and why no of attributes is less than other for same user?
Version: IDM 7.2 SP9
Database level: Patch 7
Runtime patch: Patch 4
Database: MS SQL 2012
Please let me know if more information is required. TIA