Hi all,
I am relatively new to using Oracle and working with RPD.
I have 4 tables from different Environments (No common key between them except the Unit/department) So I am making a unique join between them all based on Unit + department names .
the tables come from the database with no concatenated column, where should I create this column in each table in order to join them ? Physical Layer ?
please note : tables come from the cloud to the database and from there I want to bring them to OBIEE
Thank you !