JSON, TDM and MongoDB input and output w/o loosing nested hierarchies
I would like to be able to process MongoDB (JSON) hierarchies in and out out Talend Integration & Mapping perspectives without loosing nested hierarchies. The mapping perspective works fine with JSON but how do I get nested loops in and out of TDM in a integration Job. The problem is not so much moving things at the top of the hierarchy at a field level but more how JSON is defined as both input and output in the DI metadata. I don't think nested looping is possible. This may be possible today and I might be miss-using components or we have to consider how effective we will be in the MongoDB area without these capabilities. It would be nice to treat JSON hierarchies more like we treat XML. Leave them intact and maybe even have a TJSONMAP component and then move at the field level leaving all hierarchies intact.