Difference between Full Purge and Incremental Load and possibilities of using each one.

[adriangalisteo]

Hello community,

This question may seem basic, and perhaps it is, but in the documentation, the definition of the difference between Full Purge and Incremental Load does not make clear the differences and possibilities of using each one.

What is the real difference between Full Purge and Job Info for practical purposes?

As I read on iternet:

In Full Purge, all existing records in the system are overwritten, with the records from the new files. In incremental load, the updated fields are recorded in the system. I can understand that definition for an incremental Load if it is a partial import, but what is the difference between uploading a template with 1 line, and pressing full purge or incremental load?

The result would be the same so I would like to know where they differ in order to use them correctly.

In Job Info for example if I understand the difference since a full purge deletes all the records of the same code and saves in the system the data we have in the files.

If you do incremental load you overwrite only the line you want to overwrite or add. It is also possible with incremental load, just upload the columns you need to add without affecting the rest. So i guess is the same in Compensation Info.

But in the rest of the portlets that do not have a historical record, is there any difference between using full purge and partial import?

Best regards

[Alina]

Hello, agali,

Incremental purge only add new records and update values of old records. Full purge deletes all existing records and create new records as specified in the upload file.

None effective dated objects only keep one record without timeslice information. The results are the same using either purging option when importing data for none effective dated objects.

Importing data by incremental purge works at the record level. If we import the example file to the system by incremental purge, we get the following result:

• If a record in the upload file finds no record in the system with the same entity code and effective start date, this record is added as a new record in the system.
• If a record in the upload file matches an existing record meaning that they have the same entity code and effective start date, the old record is replaced by the record in the upload file.
• Other existing records remain unchanged in the system.

Importing data by full purge works at the entity level. If we import the example file to the system by full purge, we get the following result:

• Existing records of the same entities are deleted from the system and replaced by entries in the upload file.
• Existing records that aren't specified in the upload file remain unchanged in the system.

I hope it helps,

Best regards,

Alina

[adriangalisteo]

Hi Alina thanks for your amazing answer,

Regarding the Full Purge, when you say entity, it means that it will delete all the records that have the SAME CODE right?

Greetings

[Alina]

Hello, agali,

Yes.

Alina