How to resolve the issue of flatten object not able to flat all the elements in TIBCO Data Virtualization MongoDB data source?
Article ID: KB0072268
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 8.4,8.5,8.5.1 |
Description
When creating a TDV mongodb connection with "flatten object" and "flatten array", the nested elements are still not flattened.
We can see sub-columns for object type but not for array even after selecting the flatten object and flatten array.
The below suggestion will be helpful.
We can see sub-columns for object type but not for array even after selecting the flatten object and flatten array.
The below suggestion will be helpful.
Issue/Introduction
How to resolve the issue of flatten object not able to flat all the elements in TIBCO Data Virtualization(TDV) MongoDB data source.
Environment
Windows
Resolution
- Follow the reference article to set the parameters to use "flatten object" in MongoDB data source.
- Now, set the 'FlattenArrays' value to -1 in your data source configuration and save the changes made.
- Delete the previously introspected tables, and introspect again.
The value "-1" here would flatten all the elements of the nested array of objects,
Additional Information
Feedback
Yes
No
Powered by
