ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 28-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
Now I am joining these two table on the basis of col1=fac1 AND col2=fac2 AND col3=fac3 in RPD physical layer and defining inner join in BMM layer. I want to display the sales(fac4) for 'CH'(col5), So as it is inner join its taking all three combinations available in EMPLOYEE TABLE and its multiplying the value three times, but I want to take only one combination of the three columns from EMPLOYEE TABLE.
Please put some light here. How I can take only distinct values.