Its kind of really urgent and important to me.
I have a prompt which hold the emp name. In the list of values i need only the list which comes when is join the emp table with the fact.
Like is its a SQL it would be lik this.
from w_emp_d e, fact f
where e.row_wid= f.emp_wid