scenario Regarding update

Devendrudu · Post by **Devendrudu** » Fri Aug 12, 2011 9:34 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Aug 12, 2011 4:06 pm

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.

Ravi.K · Post by **Ravi.K** » Sat Aug 13, 2011 2:44 am

Change Capture Stage could help you.