Join Entity Example

Join Entity - Denormalized 

<IndexEntity joinTable="true">
   <Name>PersonToAddress</Name>
   <EnterpriseName>ABC</EnterpriseName>
   <Repository>
       <RepositoryName>PERSON</RepositoryName>
       <AttributeList>
          <Attribute>	
               <AttributeName>FNAME</AttributeName>
          </Attribute>		
          <Attribute>
               <AttributeName>LNAME</AttributeName>
          </Attribute>	
       </AttributeList>
       <Relationship>
               <RelationshipName>PTOA</RelationshipName>
               <RelatedRepository>ADDRESS</RelatedRepository>
       </Relationship>
   </Repository>
   <Repository>
       <RepositoryName>ADDRESS</RepositoryName>
       <AttributeList>
          <Attribute>
               <AttributeName>CITY</AttributeName>
          </Attribute>
          <Attribute>
               <AttributeName>COUNTRY</AttributeName>
          </Attribute>
       </AttributeList>
   </Repository>
</IndexEntity>

Join Entity - Normalized

<IndexEntity joinTable="true" normalized="true"> 
   <Name>STAR4LEVEL</Name>
   <EnterpriseName>DQ</EnterpriseName>
   <Repository>
       <RepositoryName>PERSON</RepositoryName>
       <AttributeList>
           <Attribute>
               <AttributeName>FIRSTNAME</AttributeName>
           </Attribute>	
           <Attribute>
               <AttributeName>LASTNAME</AttributeName>
           </Attribute>	
           </AttributeList>
           <Relationship>
               <RelationshipName>RESIDESAT</RelationshipName>
               <RelatedRepository>ADDRESS</Related repository>
               <RelationshipAttributeList>
                   <AttributeName>ADDRESSTYPE</AttributeName>
               </RelationshipAttributeList>
           </Relationship>
           <Relationship>
               <RelationshipName>HASPHONE</RelationshipName>
               <RelatedRepository>PHONE</Related repository>
           </Relationship>
           <Relationship>
               <RelationshipName>HASACCOUNT</RelationshipName>
               <RelatedRepository>BANK</Related repository>
           </Relationship>
           </Repository>
           <Repository>
               <RepositoryName>ADDRESS</RepositoryName>
               <AttributeList>
                   <Attribute>
                       <AttributeName>STREET</AttributeName>	
                   </Attribute>
                   <Attribute>
                       <AttributeName>CITY</AttributeName>
                   </Attribute>
               </AttributeList>
           </Repository>
           <Repository>
               <RepositoryName>PHONE</RepositoryName>
               <AttributeList>
               <Attribute>
                   <AttributeName>CELLNUMBER</AttributeName>
               </Attribute>
               <Attribute>
                   <AttributeName>WORKNUMBER</AttributeName>
               </Attribute>
               <Attribute>
                   <AttributeName>HOMENUMBER</AttributeName>
               </Attribute>
           </AttributeList>
       </Repository>			
       <Repository>
           <RepositoryName>BANK</RepositoryName>
           <AttributeList>
               <Attribute>
                   <AttributeName>BANKNAME</AttributeName>
               </Attribute>
               <Attribute>
                   <AttributeName>BANKACCOUNT</AttributeName>
               </Attribute>
               <Attribute>
                   <AttributeName>BANKADDRESS</AttributeName>
               </Attribute>
           </AttributeList>
       </Repository>
   </IndexEntity>