Replicate - How to create PRIMARY INDEX rather than PRIMARY KEY in Teradata Target DB

[john_wang]

Sometimes the target default endpoint behavior does not meet our needs. This  article is useful  if we want to modify the default syntax. 

For example while Teradata is target endpoint, Replicate creates PRIMARY KEY by default if the source table has the PRIMARY KEY as well.  User want to create PRIMARY INDEX rather than PRIMARY KEY in Teradata Target tables.

The below steps demonstrate how to custom the CREATE TABLE behavior.

 

Environment

• Qlik Replicate All supported versions
• Teradata           All supported versions

 

Detailed Steps:

1.  Open "Manage Endpoint Connections" in Replicate console GUI

2.  Go endpoint "Advanced" tab and add "Internal Parameter"

      The internal parameter name is:

$info.query_syntax.create_primary_key

      press enter after the input, it will appear in the below Parameter-Value matrix.

4. Assign the above parameter value as:

) PRIMARY INDEX ( ${COLUMN_LIST}

      The screencopy looks like:

5. Run the task.

 

Related Content

Another approach : How to custom target endpoint syntax 

Support case # 00043847

Qlik Replicate  

[john_wang]

Sometimes the target default endpoint behavior does not meet our needs. This  article is useful  if we want to modify the default syntax. 

For example while Teradata is target endpoint, Replicate creates PRIMARY KEY by default if the source table has the PRIMARY KEY as well.  User want to create PRIMARY INDEX rather than PRIMARY KEY in Teradata Target tables.

The below steps demonstrate how to custom the CREATE TABLE behavior.

 

Environment

• Qlik Replicate All supported versions
• Teradata           All supported versions

 

Detailed Steps:

1.  Open "Manage Endpoint Connections" in Replicate console GUI

2.  Go endpoint "Advanced" tab and add "Internal Parameter"

      The internal parameter name is:

$info.query_syntax.create_primary_key

      press enter after the input, it will appear in the below Parameter-Value matrix.

4. Assign the above parameter value as:

) PRIMARY INDEX ( ${COLUMN_LIST}

      The screencopy looks like:

5. Run the task.

 

Related Content

Another approach : How to custom target endpoint syntax 

Support case # 00043847

Qlik Replicate