How to eliminate duplicate values in input for StoredId data connector when using RelationalDatabase data connector
cantor.2 at osu.edu
Fri Apr 1 12:26:41 EDT 2016
> Let's consider a database view "view_attributes" that produces the following
> result set:
That form would make a SQL guy like myself want to stab somebody. ;-)
Yeah, that's not a proper table. It needs to be denormalized, and if that was the result of a query, you need two queries.
> The RelationalDatabase data connector doesn't provide some option to
> remove duplicate values, does it?
No, the result set was meant to be exposed as a set of "rows" so that the values in each position correspond. That's why the value collections are ordered.
> May we need to use multiple RelationalDatabase data connectors,
> one per multi-valued attribute and one for the remaining single-valued
More information about the users