Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How to join 2 tables, without using any condition?

asked marvit February 18, 2015 04:07 PM  

How to join 2 tables, without using any condition?


3 Answers

answered By Raghu .   0  
yes we can join ...but it is cartesian join (joining two tables without any condition)
   add comment

answered By   0  

It is possible with a cross join query like below:

select * from a,b.

if table a having 5 rows, table b having 10 rows, the result will be 5*10 = 50 rows.

   add comment

answered By Mswami   0  
It is not possible to actually possible to join two tables without using any condition. If we would like to join two tables, then in source qualifier transformation add all the ports from two tables(if both tables are from same database source) and write down your join condition in user defined join option or otherwise write down join condition inside the sql query option with generated SQL query (OR) simply use a dummy condition like 1=1.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!