Question

Add a timestamp field

  • 6 September 2023
  • 2 replies
  • 49 views
B
Rank
Badge
  • brmo
  • Do Gooder (Customer)
  • 1 reply

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 ?

 

2 replies

E
Rank

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
 

B
Rank
Badge

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

Reply


Terms & ConditionsCookie settings