Which Teradata operator is specifically noted for not locking target tables?

The Stream Operator is specifically designed for data manipulation in such a way that it does not lock the target tables. This feature allows for concurrent access to the tables, making it particularly useful in scenarios where maintaining availability and performance is crucial. By avoiding locks, the Stream Operator can efficiently stream data into or out of tables while other processes continue to operate without disruption.

This is different from other operators, like the Load Operator and the Update Operator, which typically require table locks to ensure data integrity during the data load or update processes. The Export Operator, while also functioning without locking the target, is primarily focused on extracting data rather than streaming it in real-time like the Stream Operator. This unique capability of the Stream Operator makes it a valuable tool for real-time data integration and updates in a multi-user environment.