hi,
i am trying to create a less than equal cardinality in framework manager. But i am getting full outer join issue.
This is how the data looks:
Department Department1
100000 100000
100001 100001
100002 100002
100003
100004
But because of full outer join, i am getting 3 * 5 =15 rows
all i am trying to achieve is when
department1 = 100003, then i will get in department (100002)
department1 = 100004, then i will get in department (100002)
department1 = 100002, then i will get in department (100002)
please advice
Aren't you confusing full outer join with a cross join? A cross join would yield 3x5 combinations
A <= join would fetch 3+3+3+1+1 = 11 combinations