DataSet/Fileset Update policy

[adarsh shrinagesh]

Hi

Whats the difference between the

Use existing (Discard records) and the Overwrite option in Filesets and Dataset

According to the output I see the only difference is that overwrite create the fileset/Dataset if it is not already created without any warning while a warning is thrown in the latter case

Both delete all records and then insert.

Thanx

[adarsh shrinagesh]

In continuation
Another diff between Use existing (Discard records) and the Overwrite option wud include:

The schema file would be generated afresh with the overwrite option and that it remains as is in the case of Use Existing(Discard records).

But then wont that also be done through the Use existing (Discard records and schema) option.

[gbusson]

The fileset are made of different files :

the datafiles and the "control" file, which contains the schema and the localisation of the different datafiles (node and pathname).

the options :

Use existing : (Discard Records) : you do not change the name of the datafiles.

Use existing (Discard schema &records) : you rebuild the schema but you do not change the name of the datafiles

these options are useful when you create your datafiles manually before executing your job.

Overwrite : you change everything.