Once you identify the requirements for moving data from an external data source to Teradata Database, you must select the components the script will use to execute the job. There are three types of components you need to consider:
- A producer operator that reads data directly from the external source and places it in the data stream.
- A producer operator that uses an INMOD routine or access module to access data from an external source and then pre-process the data before sending it into the data stream.
- A consumer operator that takes data from the data stream and writes it to the Teradata Database.