Source Owner, Administrator, Super User
You can add multiple targets for a single source.
Listener does not support insert of JSON data beyond 64000 bytes.
- Select .
-
Complete system and target configuration with the following considerations:
Target Setting Consideration QueryGrid - Provide the Foreign Server.
- If you save the System Connection information, you cannot remove the QueryGrid option. You must create a new target without the QueryGrid option.
- QueryGrid targets cannot be changed to a JDBC target. You must create a new target.
- Each target must be mapped to a new table (a table that is not currently mapped to any target).
Shred Column, Custom Mapping - In From Source, enter valid JSON elements from your payload for each column.
- Listener does not support insert of JSON data beyond 64000 bytes.
- Delete unneeded columns.
- Add additional mapping using ADD MAPPING.
- For time series sequenced table, you must provide mapping for the 'td_seqno' column. If you do not provide mapping, the following error occurs:
Data validation error: Column 'td_seqno' mapping should be provided
- For time series data, you can write to PTI tables in Teradata NewSQL Engine systems. When creating a target, you can either map to the TD_TIMECODE PTI table column or allow Listener to insert the TD_TIMECODE column value as the timestamp when the record is inserted in the Teradata NewSQL Engine system.
- [Optional] To prevent target changes, turn Lock Target on.