Given the following set of data for a FACT TABLE. EMPLOYEEKEY DEPARTMENTKEY SALARY Gender (11, 'Sales', 10,'Male',) (12,

[answerhappygod]

Given The Following Set Of Data For A Fact Table Employeekey Departmentkey Salary Gender 11 Sales 10 Male 12 1 (20.88 KiB) Viewed 45 times

Given the following set of data for a FACT TABLE. EMPLOYEEKEY DEPARTMENTKEY SALARY Gender (11, 'Sales', 10,'Male',) (12, 'HR', 10,'Female',) (13, 'IT', 20,' Female',) (14, 'Marketing', 30,'Male',) (15, 'Finance', 10,' Female',) (16, 'Sales', 20,'Male',) (17, 'HR', 20,'Male',) (18, 'Marketing', 10,'Female',) (19, 'Finance', 20, 'male',) (20, 'Sales', 20,'Female',) (20, 'Sales', 30,'Female',) Using HQL i) ii) Given a file "employees.txt", write the detail steps to create and populate the "employees" table in Hive. List the number of employees in each department