create table W_EMPLOYEE_STG
(employee_id number,
first_name varchar2(100),
last_name varchar2(100),
email varchar2(50),
phone_number varchar(50),
hire_date date,
job_id varchar2(20),
salary number,
commission_pct varchar2(10),
manager_id number,
department_id number);
create table W_EMPLOYEE_TRG
(employee_id number,
first_name varchar2(100),
last_name varchar2(100),
email varchar2(50),
phone_number varchar(50),
hire_date date,
job_id varchar2(20),
salary number,
commission_pct varchar2(10),
manager_id number,
department_id number);
create table W_DEP_D (department_id number , department_name VARCHAR(20));
insert into W_DEP_D values(50,'Sales');
insert into W_DEP_D values(40,'Finance');
insert into W_DEP_D values(110,'HCM');
insert into W_DEP_D values(70,'SCM');
insert into W_DEP_D values(90,'R and D');
insert into W_DEP_D values(30,'HR');
insert into W_DEP_D values(10,'EPM');
insert into W_DEP_D values(20,'AD');
insert into W_DEP_D values(60,'Tech ERP');
insert into W_DEP_D values(100,'Innovation');
create table W_EMPLOYEE_F
(EMPLOYEE_ID NUMBER,
FIRST_NAME VARCHAR2(100),
LAST_NAME VARCHAR2(100),
EMAIL VARCHAR2(50),
PHONE_NUMBER VARCHAR2(50),
HIRE_DATE DATE,
JOB_ID VARCHAR2(20),
SALARY NUMBER,
COMMISSION_PCT VARCHAR2(10),
MANAGER_ID NUMBER ,
DEPARTMENT_NAME VARCHAR2(10) )
create table W_DEP_ARG
(department_id number,
salary_sum_by_department number);