How is Cartesian join performed using a join stage?

I have
source
10
20
20
reference 10
20
20
can someone tell me how a cartesian join performed using a join stage in datastage.
Thanks
Sravanthi
  • Interview Candidate
  • 2
  • 5449

Showing Answers 1 - 2 of 2 Answers

satjay

  • Mar 17th, 2015
 

create a dummy key column in both the links (eg with value 1) and join with this key column. This is the approach to join two tables without keys.

  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