HI,
Please help me with delta import form one oracle table into solr. I don't
have any primary key in the table. We need to use composite key using
(LOCAL_MASTER_ID,LOCAL_ID).
<entity name="item" pk="ID" transformer="TemplateTransformer"
query="select * from data.vw_data_ref"
deltaQuery="select concat(LOCAL_ID,LOCAL_MASTER_ID) as ID from
data.vw_data_ref where UPDATED_DATE >
to_date('${dataimporter.last_index_time}', 'YYYY-MM-DD HH24:MI:SS')"
deltaImportQuery="select concat(LOCAL_ID,LOCAL_MASTER_ID) from
data.vw_data_ref where ID='${item.ID}'">
<field column="ID" template="${item.LOCAL_ID}${item.LOCAL_MASTER_ID}" />
</entity>
-----
Regards
Shruti
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
