I am a new to MDM validations. So I want to know approach for validations like below. Say I have a Employee Table with fields
RecordID | Emp. Number | Name | Unit | Date Join | Date Resign
Validation requirements are
1. Say in case employee resigns and joins again there is going to be new entry added. In this case 'Date Join' should be greater than 'Date Resign' of previous record of his.
2. Employee should be assigned to only one 'Unit'
3. Employee number can not be duplicate. etc
Is this possible with validation within Data Manager? Your help/links/pointers are very much appreciated.
Edited by: Sagar Lipare on Apr 14, 2010 1:51 AM