OBIEE - Stitch Join (Intern Join Operations)

Bi Server Architecture With Client


Stitch Join are join operations performed by OBIEE with its intern engine: the Oracle BI Server’s join engine.

The BI Server creates TMP (temporary) files in the ORACLEBIDATA/tmp directory

The Oracle BI Server’s join engine is seamlessly invoked when necessary, depending on the following:

  • physical location of tables,
  • SQL functionality supported by the source database(s),
  • and analytical complexity of the original logical query.

Join plans are constructed to maximize collective function shipping down to the source databases. Two types of internal join strategies are currently supported:

  • (1) sort-merge,
  • (2) nested loop, parameterized query joins.

Implication of the driving Table

The implication of a driving table in a nested loop join : Nested Loop - Driving Table.

The driving table is generally very small and the other table large in the join.

Documentation / Reference

Discover More
Bi Server Architecture With Client
OBIEE - BI Server (OBIS|nqsserver|nqs)

OBI Server is also known as: OBIS (Oracle Business Intelligence Server) or nqsserver (The process name) OBI Server is principally a query and analysis server software: that can integrate data...
Obiee Fact Cross Join
OBIEE - Densification with the fact-based fragmentation capabilities

You may want to view the data in dense form, with rows for all combination of dimension values displayed even when no fact data exist for them. The preservation of the dimensions is is also well known...
Bi Server Architecture With Client
OBIEE - Federated Query / Multi-Database or Cross-Database Join

Data can exist in many different places. Instead of moving data to a single database, the BI Server can access multiple databases simultaneously to answer a single query, regardless of whether the databases...
Bi Server Architecture With Client
OBIEE - How to control the use of the WITH CLAUSE and of STITCH Join ?

The physical sql issued when you have designed a vertical fragmentation depend of several database features parameters: PERF_PREFER_MINIMAL_WITH_USAGE: if checked, the WITH clause is not used PERF_PREFER_INTERNAL_STITCH_JOIN:...
Bi Server Architecture With Client
OBIEE - Join

This article talk the SQL joins in OBIEE. You have two ways to define a join in OBIEE: in the repository when you model : in a logical sql statement OBIEE can perform internal join in its...
Bi Server Architecture
OBIEE - Oracle BI Server Execution Engine

The Oracle BI Server execution engine is a parallel SQL execution engine extended with analytical execution operators. It leverages the sophisticated technology and architectural concepts developed over...
Bi Server Architecture With Client

PERF_PREFER_INTERNAL_STITCH_JOIN is a database feature parameter. This parameter controls where a full outer join is performed. If it's checked, the full outer join is performed by BI Server (See stitch...
Bi Server Architecture
OBIEE - Query Compiler

The query compiler is responsible of the compilation of a logical sql in the query processing process of BI Server. The query compilation is composed of the following five phases: parsing, , navigation,...
Exp Builder Ago Td
OBIEE - Time Series Conversion Functions : AGO and TODATE

Time series functions in OBIEE. The implementation of the time serie function is based on the time dimension. ( See set up time dimensions) At query time, the Oracle BI Server then generates SQL that...
Obiee 11g Aggregate At
OBIEE 10G/11G - Period to period comparison with the AGO Function

Ago is a time function that calculates the aggregated value from the current time back to a specified time period. This function is useful for comparisons, such as Dollars compared to Dollars a Quarter...

Share this page:
Follow us:
Task Runner