Cartesian Products in 2 flat files

Asked By catlin bred 60 points N/A Posted on - 04/14/2012

I do have some flat files and I want to perform cartesian product. How do I do it?

• Status: Open
• Question Views: 1038
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Query Syntax

Answered By JOY Schilling 5 points N/A #148364

Cartesian Products in 2 flat files

Hello Dear,

If you want to join 2 flat files or tables by using the Cartesian product so you should set condition 1 = 1 in join and then just take the expression after two sources qualifier and define a numeric output port with that value which is equal to 1 in the both expressions and then use this column as join condition.

Hope my solution will be helpful for you.

About JOY Schilling

Questions
1

Answers
100

Best Answers
28

• Vote Up 0 Vote Down

• Posted on - 11/19/2012
• Question Category: Query Syntax