MongoDB V2 sources in mappings

Joining multiple objects

1In the Source transformation properties, select the Source Type as Multiple Objects.
2From the Actions menu, select Add Source Object, and then select the source object that you want to add from the displayed list.
3From the Related Objects Actions menu, select the Advanced Relationship option to define the relationship between the tables.
The following image shows an advanced relationship condition defined between MongoDB tables:

Note: You can join only two source tables. You must define only the join condition, not the complete join query.

Adding and removing source fields

You can add fields to a mapping source and retrieve a field from the source object that is not displayed in the list. To add a field, click , and then enter the field name, type, precision, and scale. You can also remove fields that you do not want to use in the mapping. To remove a field, select the field and then click .

Filter formats

• •Equals - { "field": "value" }
• •Not equal - { "field": { "$ne": "value" } }
• •Greater than - { "field": { "$gt": "value" } }
• •Greater than or equal - { "field": { "$gte": "value" } }
• •Less than - { "field": { "$lt": "value" } }
• •Less than or equal - { "field": { "$lte": "value" } }
• •Combines filters with logical AND - { "$and": [{ "field1": { "$gt": "value1" } }, { "field2": { "$lt": "value2" } }] }
• •Combines filters with logical OR - { "$or": [{ "field1": "value1" }, { "field2": "value2" }] }Inverts a filter - { "field": { "$not": { "$eq": "value" } } }
• •Matches documents with the specified BSON type - { "field": { "$type": "string" } } / { "field": { "$type": "int" } }
• •Matches if field’s value is in the provided array - { "field": { "$in": ["value1", "value2", "value3"] } }
• •Matches if field’s value is not in the provided array - { "field": { "$nin": ["value1", "value2", "value3"] } }
• •Regular expression matching - { "field": { "$regex": "pattern" } } / { "field": { "$regex": "pattern", "$options": "i" } }