Master Data Time Dependent

Hi Ajay , kishore, srini,bhanu and other experts. please help me here. I have a requirement to load the master data and now some master data such employee manager is time dependent so say for a july 2006 month manager name is john and the in august 2006 it manager name is mike, so like that user has few more time dependent master data.

please tell me in exact steps how to handle this ,

1. one way is by clicking on time dependent master data

for "manager name" attribute and use the key date is query so every time i load the data with flat file it should create a new entry with time stamp in q table and i can pull that manager name for all record for a period by using key date in query correct me if this works but it overload system

"But user want to put in transactional data and link it with master data i do not know what it is please tell me the approach so that i can make the user happy

all experts please help

soniya