Exact Use of Filter in Table Comaprison Data services 4.2

[Former Member]

Hi All,

I tried using table comparison Filter option in DS 4.2,when i have given any filter value and execute the job, It is throwing PK error, as it is trying to insert not Update.

It is excluding that filter value and  rest all rows are getting inserted rather updating that’s  why it is throwing PK error.If i remove filter condition and execute, its working fine.

Can any one help understand,what is going wrong.

Appreciate your response.

Thanks,

Keerthi.

[Former Member · Accepted solution]

Hi,

Check this -

Thanks,
Arun

[Former Member · Accepted solution]

Thanks Arun

Thanks,

Keerthi.