Creating MongoDB document structure

Sambi09 — Sat, 16 Nov 2024 01:33:54 GMT

Hello - I need to insert data from Oracle to MongoDB after certain transformation.

The MongoDB document will have an Object to hold the Oracle data.

Sample Input CSV created out of Oracle DB:

Mbr_id,Name,Age

2,Tim,22

---------------------------------------------

Sample Json expected in MongoDB:

{

"date":"20200830",

"detail":

{

"id":2,

"name": "Tim",

"age:22

}

I am manually putting in the Parent Node for every field in tMongoDBOutput component. However, my actual structure has 1000 fields.

Is there a way I can import the MongoDB schema along with the Parent Node for every field and avoid manually entering Parent Node for 1000 fields.

topic Creating MongoDB document structure in Talend Studio