I'm currently trying to display the operation codes, which are internally maintained during the table comparison transformation. The solution I would use right now is this:
- 1. Take a source file and use a Table comparison to create operation codes (At that point they are only displayed internally).
- 2. Use a Map Operation Transform to populate tables with just one operation code each table.
You will now have 4 tables, one for every category.
- 3. Use a query Transform to add a operation code column to each table and populate it by hardcoding. Meaning: All rows in the insert table to ‘Insert’, all in the update table to ‘update’ and so on.
- 4. Now you have 4 tables with operation codes. The only thing left to do is make one table out of this four by using the merge transformation.
I feel like this is a very unefficient way to do this and would be very happy if one of you could provide a more elegant solution.