Skip to main content

Hello,

In order to load data from INVENTORY_TRANSACTION_HIST2 to DW, it took a lot of time, actually using OBJVERSION to load a latest one but still taking 2 hours only for this table. Is is possible to add a timestamp field directly to a view INVENTORY_TRANSACTION_HIST2, and if any information change in a row the timestamp will be updated ?

 

Yes, you can add a timestamp field directly to the view INVENTORY_TRANSACTION_HIST2, but it may not necessarily improve the data loading performance significantly. YourTexasBenefits
 

Thanks @Ellabooth  for your answer, how could we add that ?

Reply


Terms & ConditionsCookie settings