- Given The Following Set Of Data For A Fact Table Employeekey Departmentkey Salary Gender 11 Sales 10 Male 12 1 (20.88 KiB) Viewed 47 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