Can't we use Map_Operation Transform object with all criterias in one shot

[Former Member]

I am looking at an existing job in my project, where they used "map_operation" transform object for each criteria, is it not possible to track all Inserts, Updates and deletes in one shot using one Map_Operation transform object?

This is how it is within a job right after Tbl_Comparison Object:

one for to track Update
(Normal-discard, update-normal, insert-discard, delete- discard)

One for to track deleted rows
(Normal-Discard, update-Discard, insert-discard, delete- Normal)

one for to track newly inserted rows.
(Normal-discard, update-Discard, insert-Normal, delete- discard)

Thanks a lot for the helpful info.

[Former Member · Accepted solution]

I forgot to answer your questions - yes it is possible to process all operation codes through one map operation.

[Former Member · Accepted solution]

Hello Michael,

The problem is they are using three map_op transform objects and immedeately connected to three qry_trnsfrms and then merge object, to merge all data...

I did not see any tweaks or logic to have individual map_oper trnsfm objects.

Thank you very much for the info.

[Former Member]

It is common to use multiple map operation transforms where you need to apply separate logic for the various operations.  For example, you might want to process a delete as a delete and an insert into an audit table,but leave inserts and updates as they are.  However, in some cases people mis-use it when applying slowly changing dimension logic.

Is there different logic after each map operation?