DSXchange

Hi,

i have one scenario.

i have 12 files that is Jan_file,Feb_file,mar_file,APR_file......Dec_file.

Jan_file
Id,Sal,month
1,100,Jan
2,200,Jan
3,300,Jan

when ever query the Jan_file i am getting these 3 Records.

Feb_file
id,Sal,Month
1,100,Jan
2,200,Jan
3,300,Jan
3-1,400,Feb

In this when ever i query the Feb_file i want only new updated Records and Non updated Records from last Month that is i Don't want 3,300,Jan Record. like that i want data how will query the data.

Please let me know.

Write out the logic in English. This will help you to understand what you need to implement using your query. It is better to learn understanding than to be handed solutions.

Change Capture Stage could help you.