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.
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,
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.
Additional Information
Was this article helpful?
Yes
No
Powered by
