MongoDB output collection with JSON tree attribute type 'objectid'
Friends,
Im a beginner to talend, creating a job to load data from MySQL to MongoDB. We have two collections (MASTER and DETAIL) in MongoDB, we load MASTER collection first and '_id' field of type 'ObjectId' is generated automatically. While loading DETAIL collection, we want the '_id' from MASTER collection to be assigned to a new field in DETAIL collection on certain join criteria in 'tmap'.
We are using JSON tree in tMongoOutput component to configure the collection structure, here '_id' field from MASTER collection is loading only as String field. Our expection is output field type should be 'ObjectId'. In JSON tree, is there any attribute type like 'objectid'?
