Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm connecting 2 tables using a key. It works.
But when i join 2 tables using the same key, it is not able to join and my PC runs out of memory and fails.
Not able to understand what is the issue.
Can someone please help? Attached picture shows connection.
How unique are your KEY values? You could be asking for a crazy large Cartesian product if it's a small distribution with a lot of records on both sides. Limited Load is your friend - try it with smaller sets of data and see what the results look like.