Property | Description |
|---|---|
Connection | Name of the MongoDB V2 connection that is associated with a dataset. You can select an existing connection or create a new connection. You can also click New Parameter to define a parameter for the target connection. |
Target Type | Type of target object. Select Single Object or Parameter. You can add multiple MongoDB V2 targets in a mapping in advanced mode. |
Object | Name of the MongoDB V2 target object based on the target type selected. You can select an existing MongoDB V2 target table to write data. When you select an existing target object, the schema is inferred from the incoming fields to the target transformation. |
Create New at Runtime | Creates a MongoDB V2 target table at runtime based on the target table you specify. To create a target table at runtime, enter the name of the target table that you want to create in the Object Name field. The agent creates the target table based on the object name and the path you specify. You can edit the metadata of the source fields before creating the target. When you create a new target at run time and the target already exists, the mapping appends the data to the existing target. |
Operation | The target operation. Select Insert, Update, or Delete. |
Update columns | The fields to use as temporary primary key columns when you update or delete data in the MongoDB V2 target tables. When you select more than one update columns, the mapping uses the AND operator with the update columns to identify matching rows. Applies to update and delete operations. |