Scenario: Mapping data using a subquery
This scenario describes a Job that maps the data from two input tables PreferredSubject and CourseScore to the output table TotalScoreOfPreferredSubject using a subquery.
The PreferredSubject table contains the student’s
preferred subject data. To reproduce this scenario, you can load the data to the table from
a CSV file like the following. For how to load data to a Teradata table, see Scenario: Loading data into a Teradata database.
preferred subject data. To reproduce this scenario, you can load the data to the table from
a CSV file like the following. For how to load data to a Teradata table, see Scenario: Loading data into a Teradata database.
|
1 2 3 4 |
SeqID;StuName;Subject;Detail 1;Amanda;art;Amanda prefers art. 2;Ford;science;Ford prefers science. 3;Kate;art;Kate prefers art. |
The CourseScore table contains the student’s subject
score data. To reproduce this scenario, you can load the data to the table from a CSV file
like the following. For how to load data to a Teradata table, see Scenario: Loading data into a Teradata database.
score data. To reproduce this scenario, you can load the data to the table from a CSV file
like the following. For how to load data to a Teradata table, see Scenario: Loading data into a Teradata database.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
SeqID;StuName;Subject;Course;Score;Detail 1;Amanda;science;math;85;science score 2;Amanda;science;physics;75;science score 3;Amanda;science;chemistry;80;science score 4;Amanda;art;chinese;85;art score 5;Amanda;art;history;95;art score 6;Amanda;art;geography;80;art score 7;Ford;science;math;95;science score 8;Ford;science;physics;85;science score 9;Ford;science;chemistry;80;science score 10;Ford;art;chinese;75;art score 11;Ford;art;history;80;art score 12;Ford;art;geography;85;art score 13;Kate;science;math;65;science score 14;Kate;science;physics;75;science score 15;Kate;science;chemistry;80;science score 16;Kate;art;chinese;85;art score 17;Kate;art;history;80;art score 18;Kate;art;geography;95;art score |
Before the Job execution, there is no data in the output table TotalScoreOfPreferredSubject:
|
1 |
SeqID;StuName;PreferredSubject;TotalScore |
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments