- Question 14 Given The Following Set Of Data For A Fact Table Employeekey Departmentkey Salary Gender 11 Sales 10 1 (124.65 KiB) Viewed 46 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)