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

[answerhappygod]

Question 14 Given The Following Set Of Data For A Fact Table Employeekey Departmentkey Salary Gender 11 Sales 10 1 (124.65 KiB) Viewed 44 times

Question 14 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) Answer. 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 (1.5 marks)