Delta import on joining two tables.

[veena rani <ve...@gmail.com>]

Hi,

I have joined two tables, i want to do delta import on it.

<dataConfig>
<dataSource driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://127.0.0.1:1433;databaseName=CLI_miniature" user="sa"
password="Password123"/>
<document>
<entity name="JobseekerDetails" query="select JobSeekerId,Name from
dbo.JobSeekerDetails">
<field column="JobSeekerId" name="Jobseekerid" />
<field column="Name" name="Jobseekername" />
<entity name="JobseekDetails" pk="JobId"
query="select JobId,Title,TechSkills,Location,ExpInYear from JobDetails
WHERE UserID=${JobseekerDetails.JobSeekerId}"
deltaImportQuery="select JobId,Title,TechSkills,Location,ExpInYear from
JobDetails WHERE JobId ='${dataimporter.delta.JobId}'"
deltaQuery="select JobId FROM JobDetails WHERE JobPostDate >
'${dataimporter.last_index_time}'">
<field column="JobId" name="id" />
<field column="Title" name="Jobtitle" />
<field column="TechSkills" name="techskill" />
<field column="Location" name="location" />
<field column="ExpInYear" name="ExpYear" />
</entity>
</entity>
</document>
</dataConfig>

i did like this, but it is not working.

-- 
Regards,
Veena.
Banglore.