Issue: w_employee_d dimension table is populating names of applicants & employees instead of full time employees only- when queried against. This is affecting reports’ results in the workforce profile subject area. Desired solution is to figure out the reason for this and to clean up this data.
Example: Samuel Deleon is the Director of IT and instead of his name appearing under the job description, Carol Myrick (who applied for a job a while ago) – her name appears instead. We need this correctly represented.
How u have done to acheive that,Can u explain that?