You want to read the employee and department information from a Teradata source, join the data, and then load the data to a Teradata target table.
Perform the following tasks to configure a
mapping
task:
Create a Teradata mapping and enter a name and description.
The following image shows the Teradata mapping:
Add a Source transformation to read employee information from Teradata using a Teradata connection. The source object used is a single object named Employee.
Some of the employee fields included are EMPID, EMPNAME, AGE, and DOB.
Add another Source transformation to read the department information using a Teradata connection. The source object is a single object named Department.
Some of the business fields included are DEPTID, DEPTNAME, and DESCRIPTION.
Add a Joiner transformation to join the employee and department information. Use the following Join condition for Master, Operator, and Detail:
Emp_DEPTID = DEPTID
Add a Target transformation to write the joined data to a Teradata table using the Teradata connection. Perform the following tasks:
Select the Teradata connection.
Use the insert operation and use a single target object named emp_dept_tgt.
In the Advanced Properties section, select Stream system operator and specify the data base version to which you want to connect.
In the Field Mapping tab, select the incoming fields that you want in the target.
The following image shows the mapped fields:
Configure a Teradata
mapping
task, add the mapping, and run the task.
The Secure Agent updates the target Teradata table.
ASK INFAPreview
