Secondary Sessions | Teradata Unity - 17.00 - Secondary Sessions - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

CDM Streaming and CDM for a non-deterministic CREATE TABLE AS query uses a secondary session to create and populate the staging table. CDM Multi-Stream uses multiple secondary sessions to load the staging table in parallel.

The use of secondary sessions increases the overall session count on the target Teradata system. You can limit the number of secondary sessions using the CDMMaxDataConnectionsPerGroup configuration parameter.