The Informatica MongoDB ODBC driver caches the schema in the MongoDB database or a flat file. After you define a schema for the collection, you can store the modifications in the MongoDB database or a file so that the
Developer tool
uses the modifications each time you import a definition.
You must modify the schema definition if there are updates to the documents that require a change in the definitions that you created in the
Developer tool
.
If you store the schema modification in a file, ensure that the file is available in the location that you configure in the ODBC data source name when you import a
data object
. If you store the schema modification in the MongoDB database, PowerExchange for MongoDB stores the schema modification in a collection called Mersenne_Collection_Metadata. If you edit Mersenne_Collection_Metadata, you may lose the schema modifications.
If you clear the metadata cache, you must re-create or re-import the source and target objects with the same metadata that the existing mapping objects use.