If I will pass Null key to Join components, then what will be output?

If I am having two table- customer and transaction. I am having 100 rows and 10 columns and I want to perform the join with NULL key, then how much output records I will get?

Showing Answers 1 - 6 of 6 Answers

Kiran

  • May 8th, 2015
 

If you are passing null key to Join component , you will get Cartesian product (input1 records X input2 records).
Thanks in Advance.

  Was this answer useful?  Yes

nagesh

  • Aug 17th, 2017
 

Cartesian product :100*10= 1000 records

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions