Hi ,
I am using Lookup Tranformation to get new and updated record from the source.
I am having one table dim_employee, I am comparing on the basis of empid, If empid is null that means its a new record else I am passing to matching records, i am taking another record to check the similar record or updated record on the basis of column mapping.
if fnam=fname,lname=lname,axles=axles then its similar else some of the column data has been updated and It will redirect to oledb command.
I am getting data correct except some data.
axles data in source and in destination are same then also every time i ma getting updated count.
i dont understand why i am getting these count when all the rows are same.
regards,
Vipin jha