Consider the following guidelines when you use NetSuite sources:
The first time an incremental load job runs to capture change data for a NetSuite source, the job retrieves and loads only the change records that are created after the date and time specified in the associated ingestion task. You can specify the date and time when you configure the source in the
application ingestion
task wizard. However, when you resume a stopped or aborted job, the job begins propagating change data from where it last left off.
When an
application ingestion
job retrieves a document or image from the source, the job propagates the unique identifier of the file cabinet that contains the document or image instead of propagating the binary content of the file.
Mass Ingestion Applications
does not capture the deletion of records from the source tables.
Incremental load jobs configured for NetSuite sources do not capture change data for the tables that do not contain the LAST_MODIFIED_DATE column. Additionally, the incremental load jobs do not capture the modification of data stored in the System_notes and System_notes_custom tables.
Incremental load jobs and combined initial and incremental load jobs configured for NetSuite sources do not detect and replicate the deletion and renaming of source fields.
Mass Ingestion Applications
does not propagate data stored in the following NetSuite tables: