Thursday, May 24, 2012

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.

4 comments:

  1. Output would be 16 records not 4

    ReplyDelete
  2. i want to pupalate ony source records i.e 4 records .can you explain please?

    ReplyDelete
  3. Thank you so much for providing information about Informatica and other related tools.I think its actually a very nice tool to explore many aspects.

    Informatica Read JSON

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...