Issues with incremental load

[vireshkolagimat]

Hi All,

I have two tables namely SalesHeader and SalesDetail. Both tables are related by 1 to many relationship.

In the header table i have field InvDate and i am using that to get the max of the invdate for incremental load. One more thing is my salesheader table contains the storename (shLocation) column and max date varies for each store. So while doing the incremental load i need to consider both  max of invdate by store wise and then do the incremental load.

I  have attached the sample data along with sql query for your reference and suggest me how to achieve the same.

Please let me know if i am missing anything in the script.

thank you.

Regards,

Viresh

[prieper]

Do you then have retroactive entries in the Store-table?

Why does the same process as for the Maintable not work?

[vireshkolagimat]

Hi Peter,

what do you mean by retroactive entries? Can you please explain?

By the way this is data generated by POS system.

Regards,

Viresh