Global Transformation in replicate

[suvbin]

can we add a new column to every table with load time of the table.

[Nimmi]

TY @john_wang ! 

Question : Is there any way to have Replicate post the time the data is committed to the target database?

Thanks

Nimmi

[john_wang]

Hi @Nimmi ,

If you want to record the exact commit time of the target DB, I think trigger is a better option - no data traffic in the network however please be careful as trigger may slow down the applying performance in target DB .

Hope this helps.

Regards,

John.

[PICTConversionTeamDevs]

We are trying to add two columns with the Global Transformation but it does not add a new column. I enabled the trace and see the below message. 
Column 'OCCLCUSR.CCX_AM_BASICRTPOLICYFIELDS.SOURCE_ROW_ACTION_CODE' will not be replicated homogeneously as it was added using a transformation

Support Case

https://community.qlik.com/t5/crmsupport/casepage/issue-id/00043027/issue-guid/5003z00002X2hmpAAB/is...

[Steve_Nguyen]

look like you open a support ticket, please work with support team on your case.