Dear [email protected], There is a new reply by kasper to the topic at the DataCleaner forum: A "no sql" schema
------------------- That's a pretty wild schema structure. Wouldn't call it "no sql" oriented, rather more like a property oriented schema. Transforming it into a regular readable table sounds like such a common requirement for such a schema, that I would recommend making a VIEW in postgres for just that. But that said, I guess you could try to apply a "Table lookup" in DataCleaner. Use the "Object" table as your source table and look up property values in the "ObjectProperty" table based on (dynamic) id_object values and (hardcoded) id_property values. Either approach won't perform great though since you need one lookup for each property. But I think that's a shortcoming of the schema model. ------------------- Please visit this URL to follow along in the discussion: http://datacleaner.org/topic/438/A--no-sql--schema -- You received this message because you are subscribed to the Google Groups "DataCleaner-notify" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/datacleaner-notify. For more options, visit https://groups.google.com/groups/opt_out.
