OBIEE Physical layer design

yaseennawaz

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

Thomas Dodds

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

Thanks for the response Thomas...

Thomas Dodds

Let us know if you hit a snag ...