Join Query
The query activity submits a join query to a join set on a TIBCO Patterns server to retrieve a record set.
General
The General tab has the following fields:
Field |
Module Property? |
Description |
Name |
No |
The name of the activity within the process. The default value is |
Patterns Connection |
Yes |
The path to the shared configuration resource which contains the Patterns Connection information. See Activities Connection. |
Show Tables |
No |
The Show Tables button displays information on existing tables, thesauri, character maps, and learn models that may be useful during query design. |
Description
Provide a short description for the Join Query activity.
Input
The Input tab has the following fields:
Input Item |
Description |
ParentTableName |
Name of the parent table to join. |
ChildTable |
One per child in the join. |
ChildTable/Name |
Name of the child table. |
ChildTable/Alias |
Alias of the child table. Child table aliases are all-or-nothing. Aliases are required if a child table is used more than once. If present, child aliases must be unique. |
SingleParentMode |
Set to Set to |
AllowOrphans |
Set to |
AllowPartials |
Set to |
GpuIndexing |
Set to |
GpuCallParallelism |
The number of GPU channels to use when processing the query. The Patterns Server calculates a default value; setting this may improve performance in some situations, but usually degrades performance. |
TableBlocksPerGpuCall |
The number of memory blocks to use per GPU unit. The Patterns Server calculates a default value; setting this may improve performance in some situations, but usually degrades performance. |
For information on other inputs, see Query Input Fields.
Output
See Query Output.