I have a requirement as below
Code: Select all
B(table)
|
A(table)---Join Stage(fullouterJoin)-------------> Transformer ----------> Matched
| |
Unmatched from A(Tfm) Unmatched from B(Tfm)
I have 6 cols in which 1 column is key(ID).
I am getting corrected output for unmatched from A,but not for Matched and unmatched from B.
constriant for Matched: left key and right key should not be null.
constriant for unmatched from A: Isnull of right key
constriant for unmatched from B: Isnull of left key Or Isnull of other cols and col <>0(some are number cols)
I have duplicates in matching keys(ID).
A count:
5000
B Count:
600000
Matched should be 4710 and i am getting 28800
unmatched from A 290 which is correct
unmatched from B should be 595290 but i am 597290
Can anyone suggest me what is going wrong in Matched and unmatched from B.
Thanks
Sudheer