Where are joins performed during Information Link execution?

Where are joins performed during Information Link execution?

book

Article ID: KB0077715

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

When executing an Information Link with data from more than one data source, a join will be performed by Information Services on the Spotfire Server. This is the logic used when determining which data source will be used by the server to perform the join.
 

Issue/Introduction

Where are joins performed during Information Link execution?

Resolution

The Spotfire Server will use the first available data source from the following list.
  1. The default join data source if defined in the Information Link (setting is DEFAULT_JOIN_DATA_SOURCE).
  2. The first writable data source in the query's data source list (the list is sorted according to FIRST_ELEMENT_TARGET or LAST_ELEMENT_TARGET).
  3. The first writable procedure data source.
  4. The first writable join data source.
  5. The default join data source.
  6. The first (in alphabetic order) wriable data source.
If none of the above data sources are available or writable, then there will be an error that the join cannot be performed.

Additional Information

Doc: Default join database:
Powered by Wolken Software