Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Where should I create calculated field for table joins?

User_AD53QAug 7 2022

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 !

Comments

Hi,

use IFrame

Frank
Branislav Nemec
Hi,

Never tried swf in ADF Faces 10g, but usually I use <f:verbatime> </f:verbatime> to include JSP or DIV or some other non JSF element

Branislav
John Stegeman
verbatim, not verbatime ;)

zaki, amr, bebo agogo memo.

Those are lovely names for forum posts
Branislav Nemec
Hi John,

you are fast... thanks for the correction. I don't know why I always misspell this tag name ?:|

Branislav
Hi,

whatever solution you choose, keep in mind that such an addition cannot be cancelled at runtime and might skow down the page loading process

Frank
1 - 5