This content has been marked as final. Show 2 replies
Instead of executing the join on Source, you can execute it on Staging Area. When you click on the join in interface diagram, in the property window there is an option to select Execute on Source or Staging Area. Try selecting Staging Area if currently Source is selected.
firtsly you need to add your table to the model using reverse engineering,
then you can join them.
you can get in touch if issue couldnt solved.