Question

NTO has to import a file that will be different every time.

What method should be used?

A. Update
B. Overwrite
C. Add and Update
D. Add Only

Answer 1

For a file that changes with every import, the 'Add and Update' method is recommended as it allows both the addition of new records and the updating of existing ones based on unique identifiers.

Step-by-step explanation:

If NTO needs to import a file that is different every time, it is generally recommended to use the Add and Update method. This method allows the import to add new records to the database and update existing ones with new information from the file. This approach is ideal for maintaining a comprehensive and current database where records may need to be revised regularly due to changes in the data. It's important to ensure that there is a reliable way to match records in the file to records in the database, typically through unique identifiers.