Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE Physical layer design

Received Response
11
Views
3
Comments
yaseennawaz
yaseennawaz Rank 4 - Community Specialist
edited Aug 13, 2024 5:38PM in Oracle Analytics Cloud and Server

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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    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.

  • yaseennawaz
    yaseennawaz Rank 4 - Community Specialist

    Thanks for the response Thomas...

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Let us know if you hit a snag ...