Output
Teradata Output
Writes the rows that reach it into an existing Teradata table, in one transaction, and passes them on unchanged.
When to use it
Use it to land prepared data in the warehouse — a staging table for a downstream load.
In a pipeline
File InputType ConversionTeradata Output
Settings
| Setting | Type | Required | Default or hint |
|---|---|---|---|
| Connection | select | Yes | Add a connection below |
| Target Table | select | Yes | Select a table |
| Write Mode | select | — | append |
| Key columns | select | — | Columns that identify a row |
Example
Stage targets
- Target Table=Stage.Targets
- Write Mode=Append rows
| StoreId | Target |
|---|---|
| 12 | 20000 |
| 14 | 11000 |
| StoreId | Target |
|---|---|
| 12 | 20000 |
| 14 | 11000 |
Worth knowing
- Inserts are sent as a batch, inside one transaction.
- Upsert deletes the incoming keys first, then inserts, in the same transaction.
- Previews never write.