Change Capture to Get the Deleted Recods.

[reddy.cba]

HI,
I will try my best to explain the Logic i am trying to build...

we have a two tables A & B
I have to get the results output to a dataset for Delete records, Edit Recods and Insert Records:

Table A has two fields A1 & A2 with the values U1, T1 & U2, T2 & U3 , T3
Table B has two fields B1 & B2 with the values U1, T1 & U5, T2 & U6 & T6

Now if we use change capture using Table A Left outer Join Table B

we get
Copy stage records : U1 & T1
Insert Stage Recods: U3 & T3
Edit Stage recods : U2 & T2
when using chane capture with Key value as Field A2:
But i am Unable to get the deleted records i.e U6 & T6.
can anyone pls suggest how i should be able to get the deleted record.
When i use right outer join i will be missing again the records in A which do not present in B.
Please suggest any alternatives.
Thanks Heaps
Reddy

[ray.wurlod]

Use SQL set operator DIFFERENCE when extracting.

[reddy.cba]

Thanks Ray,
I was able to get by making the following change:

Using Full Outer JOin
and changing the Drop Output for Column to false from Its Default Stage(True).