1 Reply Latest reply on May 26, 2015 7:51 AM by Steven Hawkins

    How does hierarchical models work in teiid?

    Himanshu Kapoor Newbie

      How does hierarchical models work in teiid ?

      If i go and create a VDB on hierarchical model , does relationship is maintained when i query on top of VDB built on this model ?

        • 1. Re: How does hierarchical models work in teiid?
          Steven Hawkins Master

          For hierarchical sources the hierarchy will be converted to a relational model using keys to express the relationships - see our sources such as JPA, MongoDB, or Salesforce, etc.  There can be a performance hits for this as the translators generally make simplify assumptions, such as only supporting source queries with a single join, to make mapping general SQL queries back to the hierarchical structure possible.