MDM Validation on the whole table data - Please help

Hello Experts,

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.

Thanks.

Edited by: Sagar Lipare on Apr 14, 2010 1:51 AM