Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE Physical layer design

Hi,
Can you please tell me if we can create a join between two tables or two views that are part of two different schemas in a database object.If it is possible then how to join them.?
Appreciate your response
Thanks,
Yaseen
Answers
-
Using fully qualified names you shouldn't have an issue ... providing your one connection pool can 'see' both schemas.
The issue of performance will arise if the schemas are in different databases - a cross database join will be slow.
To add the two tables to the physical diagram to build the join - treat them as if they were in the same schema -- there's no difference in the HOW of it all - except for the configuration of using fully qualified names.
0 -
Thanks for the response Thomas...
0 -
Let us know if you hit a snag ...
0