[G_L Entry], [Ledger Entry Dimension], [Dimension Value] and more Incremental data

Hi,

I'm new here. I'm preparing data warehouse and need import data from NAV tables. How to find which data are new sience  i readed last time and wchicha data were updated.

Especially for tables [G_L Entry], [Ledger Entry Dimension], [Dimension Value]

 

Marek

  • Create a new boolean field in every table called 'New data' and another field for Time, whenever you import the data update these new fields and when you filter on this new boolean field and Time field you will come to know that it, it was updated after the last time you ran your import.

    Thanks
    RJ.
  • Create a new boolean field in every table called 'New data' and another field for Time, whenever you import the data update these new fields and when you filter on this new boolean field and Time field you will come to know that it, it was updated after the last time you ran your import.

    Thanks
    RJ.
  • In reply to sbhatbng:

    Thank you for answer. The problem is, I can not modify tables. I can just read data to DWH.
Related