MongoDB "Flat Array" functionality is not working
Article ID: KB0081646
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.5,7.0.6+ |
Description
TDV Flatting Array is only working up to one level only and cannot flatten deeply nested object or arrays (Flatting arrays in an operation which converts nested object into columns.)
Issue/Introduction
MongoDB "Flat Array" functionality is not working
Resolution
MongodB data structure
Mongo DB table structure after introspecting in studio. First Image is without flattening data and 2nd is with flattening data
TDV Mongo DB adapter can only flatten array upto level 1 and other data is ignored.
We have to set below mentioned configuration to resolve issue.
Set:
Flatten Array = 10 <Depth of Array>
Flatten Object=TRUE
Row Scan Depth=25000 <count of rows>
Type Detection Scheme=RawScan, Recent
Feedback
Yes
No
Powered by
