Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I have a Source table where we need to do some Join with dimension and get the result
on the Result set we want to Segregate the Unique record to one table and duplicate record to one table.
How to achive this?
Emp Join with Department
Join with Location
Join with Date
and Result we want to Push to Emp Fact (with Unique emp id record)
Emp Dupl Fact(with duplicate empid record)
This duplicate record can be result of duplicate entry in Department or Location or date or Emp Table