Hi All, I am trying to index nested document. While start full data-import (from UI) following options selected Verbose, Commit, Debug & Debug-Mode.
Raw Debug-Response shows that "child" entity query execute repeatedly. Kindly help me to understand this, how can I resolve this, am I missed anything? Sample data-config.xml <document name="companies"> <entity name="company" transformer="RegexTransformer" rootEntity="true" query="SELECT * FROM COMPANY"> <field column="ID" name="c_id"/> <field column="DEPARTMENT" name="c_department"/> <entity name="employee" child="true" query="SELECT * FROM EMPLOYEE WHERE com_employee_id = '${company.ID}'"> <field column="NAME" name="e_name"/> <field column="EXPERIENCE" name="e_experience"/> </entity> </entity> </document> ------------------------------------------------------------------------------------------------------------------------------------ Raw Debug-Response: "entity:company", [ "document#1", [ "query", "SELECT * FROM COMPANY", "----------------------------------------", "transformer:RegexTransformer", [ "entity:employee", [ "query", "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'", ] ] ], "document#2", [ "transformer:RegexTransformer", [ "entity:employee", [ "query", "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'", "query", "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'", ] ] ] ] "document#3" "entity:employee", "query", "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'", "query", "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'", "query", "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'" Thanks, Prabaharan