Consider the following guidelines when you use a MongoDB connection in a mapping:
•You cannot use MongoDB Connector to read or write MongoDB column or table names that have more than 65 characters.
•You cannot fetch the details of the rejected rows when you write data to a Mongo DB target.
•If you want to configure a filter condition for the date data type in a mapping, you must specify the EnableUTCTimeZone=true property in the Additional Connection Properties field in the MongoDB connection. If you do no set the property and use the filter condition, the date from the MongoDB collection is converted to the local timezone that might lead to incorrect row selection.
•When you run a mapping with multiple pre-SQL and post-SQL queries in the advanced properties of a MongoDB source or target, the mapping fails.