Join the data of two tables which does not have common columns

Description:

Lets assume I have two source files as shown below:

SOURCE 1		SOURCE 2
EmpNo Name 100 Sivan 200 Uday 300 Chandu 400 Satish		Sal Location 2000 Noida 3000 Banglore 1800 Hyderabad 1500 Chennai

I would like to load the target a shown below:

SNo	Name	Sal	Location
100	Sivan	2000	Noida
200	Uday	3000	Banglore
300	Chandu	1800	Hyderabad
400	Satish	1500	Chennai

Solution:

1. Drag Source1, Source2, Target tables.
2. Create a Expression t/f and connect SQ_Sorce1 to Expression t/f.
3. Create a variable port say v_Dummy and assign default value as 1.
4. Create a Expression t/f and connect SQ_Sorce2 to Expression t/f.
5. Create a variable port say v_Dummy (with same name and data type used in previous pipeline) and assign default value as 1.
6. Join two piplines to a Joiner t/f. The Joinner condition v_dummy=v_dummy.
7. Connect all ports to the target.