The Options Tab
- Write mode
-
- Click Initial load if you are loading the model for the first time. The model will be locked and unable to be written to by other Write to Model stages. When this mode is checked, the only available option on the Updates tab in the Add Entity dialog box will be Never overwrite non-empty properties. Therefore, if you have multiple input files in your dataflow, they can all create properties, but none of them can update existing properties with new values. This mode provides better performance when initially loading a model. Existing data, if there is any, will be cleared prior to writing.
- Click Concurrent writes if you want to allow the model to be written to by multiple Write to Model stages at the same time. When this mode is checked, the Clear model before processing option is disabled and the model is created prior to running the job. If the model does not already exist, it will be created when the stage is closed.
- Click Exclusive lock (default) if you do not want to allow the model to be written to by multiple Write to Model stages. When this mode is checked, properties can be updated after they are created.
- Clear model before processing
- Check this check box if you wish to remove all existing entities and relationships before processing new data. If this is not selected, new information will be used to update any existing entities and relationships.
- Remove orphaned entities after processing
- Check this check box if you wish to remove entities that have no relationships.