THE TWIGSTER

Suppose you work for an HR service based company (XYZ) and this company provides technology based HR solutions to different client. HR-Technology based solution could be:- 1. Employee Management System. Employee personal and professional details with education, experience, skills and work history. 2. Leave Management System. Number of Leaves applied by the employee, leave type weather it’s a planned leave or unplanned leave. 3. Exit Management System. Employee exit management system includes weather it’s a voluntary or involuntary exit. Your task is to design a system to move different clients existing data into our data warehouse Suppose we have two clients that have buys our Employee Management System. 1. Company-A 2. Company-B As these clients are using some or other system/or excel files to store their existing employees data. Company-A Emp_Id Emp_Name Date_of_Birth Date_of_Joining Location Department Designation A001 Ajay 1-Jan-89 1-Mar-16 Delhi IT Manager A002 Vijay 13-Feb-84 1-Oct-16 Mumbai IT software Developer A003 Sunil 24-Jun-86 12-Aug-16 Chennai HR Intern Company-B Emp_Id Emp_Name Date_of_Birth Date_of_Joining Location Department Designation 100001 Anil 1-Jan-89 1-Mar-16 North Delhi Sales Executive 100002 Ankit 13-Feb-84 1-Oct-16 South Mumbai Finance Trainee 100003 Sourabh 24-Jun-86 12-Aug-16 Noida Marketing Team Lead