Problem with loading target tables
Posted: Thu Nov 11, 2004 12:45 pm
Hello there,
I have one source table(A) with details of employees. It contains Dept.Name and Dept.Number columns along with some other columns. A person can work in different departments. In the target database, I have two tables namely employee table(B) and employee_account table(C). If a person(Sam) works in departments 5 and 6, I want to load 'emp_name' column in table B with 'Sam' and also I want to have two records of 'Sam' in table C with dept_number 5 and 6. Can anyone explain me how I can accomplish this please.
Thanx in advance.
-Yamini
I have one source table(A) with details of employees. It contains Dept.Name and Dept.Number columns along with some other columns. A person can work in different departments. In the target database, I have two tables namely employee table(B) and employee_account table(C). If a person(Sam) works in departments 5 and 6, I want to load 'emp_name' column in table B with 'Sam' and also I want to have two records of 'Sam' in table C with dept_number 5 and 6. Can anyone explain me how I can accomplish this please.
Thanx in advance.
-Yamini