How to work with composite records handling in a MongoDB destination component.
A composite record models an array item in a MongoDB document. The nested document in such an array usually have the same set of fields, thus they are modeled by a separate input (named after the array element path).
For each parent record (e.g. a MongoDB document), the composite input would expect to receive a set of rows (with a row per array item). Those set of rows must be separated with blank row (all NULLs) to denote the end of the array items. The processing of the parent record will not finish until all composite record children have received blank row to indicate completion. Tip: You can use Query transform to prepare parent-child data with the proper blank rows.
For additional information about modelling of composite records in SSIS+, please refer to this article.
Book a Presales Call
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
How to work with composite records handling in a MongoDB source component.
For each array in the document, regardless of the depth of nesting, there will be created a composite output that enables retrieving the field values of its items. This output contains not only the fields of the array items, but also the fields from ...How to work with composite records handling in a rest destination component.
The composite record input accepts sets of rows, one set for each parent record. Each set of rows must be separated with blank row (all NULLs). The parent record will not finish processing its record, until all composite record children have received ...How to work with composite records handling in a Sage destination component.
The composite record input accepts sets of records, one set for each parent record. Each set of records must be separated with blank row (all NULLs). The parent record will not finish processing its record, until all composite record children have ...How to work with composite records handling in a Netsuite destination component.
The composite record input accepts sets of rows, one set for each parent record. Each set of rows must be separated with blank row (all NULLs). The parent record will not finish processing its record, until all composite record children have received ...How to work with composite records handling in a QuickBooks destination component.
The composite record input accepts sets of records, one set for each parent record. Each set of records must be separated with a blank row (all NULLs). The parent object will not finish processing its record until all composite object children have ...