SUMMARY
This document explains TPT stands for Teradata Parallel Transporter and covers the reasons why this setting needs to be disabled to correctly use the "Fetch data slices in parallel from the warehouse" under the Intelligent Cube Options > Data Partitions.
QUESTION
Under the Intelligent Cube Options > Data Partition > Fetch data slices in parallel from the warehouse, there is a legend that reads "Please disable TPT to enable this function". What does TPT stands for?
ANSWER
TPT stands for Teradata Parallel Transporter, which is a data loading utility native to Teradata. Additional information about it can be found in the following link:
http://www.teradata.com/tools-and-utilities/parallel-transporter/
When enabling the option to "Fetch data slices in parallel from the warehouse" from the Intelligent Cube Options > Data Partitions menu, TPT is required to be disabled on the database side when using Teradata as a Warehouse. Using any other database should not have any implications, given that TPT is only applicable to Teradata.
Disabling TPT is required because enabling "Fetch data slices in parallel from the warehouse" will instruct the Strategy Query Engine to prepare the SQL statements in a way that they can be parallely executed against the Warehouse. Doing so would overlap with the native Teradata functionality to try to parallelize the query executions using TPT and can cause incorrect results when retrieving the data from the warehouse.
