What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?

  1. Home

Question:What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?

1.Add one dummy port in two sources.

2.Use Joiner transformation to join the sources using dummy port

3.Use Union

4.In expression trans assign '1' to each port

Posted by R4R Team
  1. What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!