Source Qualifier Transformation - Joins:
This works based on the below query:
select * from employees e,departments d where e.department_id=d.department_id;
You can join two or more tables using the Source Qualifier Transformation. To achieve it,
Set the Property of "User Defined Join" in the Properties Tab of the Edit Transformation.
 |
| Edit Transformations - Properties Tab |
 |
| Mappng Designer |
This works based on the below query:
select * from employees e,departments d where e.department_id=d.department_id;
 |
| Left Outer Join SQL Query - HR Schema |
No comments:
Post a Comment