Implement incremental logic for Peoplesoft Tables
We have a critical requirement to send incremental data to our data lake on a daily basis. However, some of our PeopleSoft tables lack an exclusive last update date-time field. Our downstream team insists on having access to the actual transaction data rather than just views, as they plan to use it for future use cases.
Source - Peoplesoft Database
Target - Data Lake
Integration Tool - IICS
Below is the list of tables for which we need insights on implementing incremental logic:
PS_JRNL_HEADER
PS_JRNL_LN
PS_VOUCHER
PS_PYMNT_VCHR_XREF
PS_PAYMENT_TBL
PS_VCHR_ACCTG_LINE