I want to enable an MDA table to use joins, but do not seem to have the capability on a particular table.
This document https://support.gainsight.com/Product_Documentation/Data_Management_and_Integrations/Managing_Data_I... says "Note: Currently, we support creation of lookup relation only on MDA objects for which joins are allowed."
But it does not tell me how to enable joins on an MDA table where Allow Joins is set to false. I cannot seem to find this explained anywhere else either. Hopefully I have just overlooked it.
See attached image. Support Health Scorecard table shows Joins Allowed = true, but Predictive Health Scorecard shows Joins Allowed = false. Any guidance?
Best answer by steve_davisView original
Currently, we allow joins on those objects which are residing in Redshift, hence the "Joins allowed" property is true for them and those object which are still in MongoDB are non-joinable as MongoDB do not support joins.
I would discuss with team and post it if any better solution is there.
Ajit and I would to setup a call with you and answer your questions on this. Going to send you an email. In addition to this, we would also like to discuss about our additional Joins options that we are going to introduce as part of Bionic Rules.