I am new to Data Migrator Tool. In load option, for the target properties of the load I have selected update the existing record if record exists with Load Type 'Key Matching Logic'.

But is there anyway I can get how many new records were updated and which rows were updated.
Does any one have a code to share on how to write to an ETL_log Table or how to count all my etl tables.

When you view the log for the flow you it includes statistics like this that shows you the number of rows updated.

  
(ICM18372)   -- stats for target file: baseapp/scar                   
(ICM18516)   18 : Row(s) processed by job                             
(ICM18514)   18 : Row(s) accepted by target table                     
(ICM18515)   10 : Row(s) inserted into target table                   
(ICM18517)    8 : Row(s) updated in target table                       
(ICM18518)   0 : Row(s) deleted from target table                     
(ICM18520)   0 : Row(s) rejected due to validation errors             
(ICM18521)   0 : Row(s) rejected due to no match                      
(ICM18522)   0 : Row(s) rejected because duplicate exist              
(ICM18808)   0 : Row(s) rejected due to DBMS error                    

That number is also available in a process flow as the variable &CHNGD.

This message has been edited. Last edited by: Clif,

No I was refering to CDC or IUD
is there a sample code some where that record all the ETL Load row count or updated count.

I'm sorry, I don't understand. Even with load type IUD Processing (Insert/Update/Delete) from a CDC source you get the same log, and the row count are available in system variables. And in the ETLSTATS table.

Ok thanks

This message has been edited. Last edited by: Gabe,