Procedure
- Select the first tELTOracleInput component to display the Basic settings tab.
- Enter "PreferredSubject" in the Default Table Name field.
- Click [...] next to Edit schema to define the schema of the input table PreferredSubject in the schema editor.
-
Click [+] to
add four columns:
- SeqID with the DB Type set to INTEGER
- StuName, Subject, and Detail with the DB Type set to VARCHAR
Click OK to validate these changes and close the schema editor. - Connect the first tELTOracleInput component to the second tELTOracleMap component using the Link > PreferredSubject(Table).
- Select the second tELTOracleInput component to display the Basic settings tab.
- Enter "CourseScore" in the Default Table Name field.
- Click [...] next to Edit schema to define the schema of the input table CourseScore in the schema editor.
-
Click the [+] button to add six columns:
- SeqID and Score with the DB Type set to INTEGER
- StuName, Subject, Course, and Detail with the DB Type set to VARCHAR
Click OK to validate these changes and close the schema editor. - Connect the second tELTOracleInput component to the first tELTOracleMap component using the Link > CourseScore(Table).