Change Data Capture (CDC) by Pentaho

1. Click File > New > Transformation

2. Save Transformation  as CDCTest

3. Expand Input > Drag Data Grid Into CDCTest Form

4. Click Data Grid as source data
5. Change Step Name : Data Grid Source
6.Insert Meta Tab : Code and Desc

7. Click tab Data
8. Insert Data Code and Desc

9. Drag another Data Grid as target data

10.Insert Meta Tab : Code and Desc

11. Insert Data Tab : Code and Desc

12. Expand Join > Drag Merge Rpw (diff)

13. Drag arrow from Data Grid Source to Merge Rows (diff)
14. Drag arrow from Data Grid Target to Merge Rows (diff)

15. Click Merge Rows (diff)
16. Set Reffrence rows origin : Data Grid Target
17. Set Compare rows origin : Data Grid Source
18. Keys to match : Code
19. Values to compare : Desc

20. Expand Flow > Drag Dummy (do nothing)

21. Drag arrow from Merge Rows (diff) to Dummy (do nothing)

22. Click Run > Launch

22. Highlight Dummy (do nothing)

23. Click Preview Data and see flagfield column
24.Finish