Hi All,
I have to create a table (Table 3) from two tables.
Table 1 - Updates once a day and has previous day data
Table 2 - Updates every hour and has current day data.
Example of Table 2 data -
Dec 4, 1 am update - It will have data between 12 am - 1 am, Dec 4
Dec 4, 2 am update - It will have data between 12 am - 2 am, Dec 4 (Previous hour data may change hence including data starting 12 am)
Dec 4, 3 am update - It will have data between 12 am - 3 am, Dec 4 and so on until 12 mid night
Table 3 = Table 1 (Dec 4) + Table 2 (Dec 5)
Is there a way to update table 3 where I can overwrite existing table 2 data every hour. If it was just 1 hour data every hour then I could have used append but since every hour has previous hours data, I'll have to overwrite.
My current solution - Overwrite Table 3 every hour which will overwrite both Table 1 and Table 2. I am avoiding this solution because Table 1 has historic data and large to overwrite every hour.
I have tried my best to explain my scenario but if there is still anything confusing then please let me know. I'd highly appreciate any help.
Thanks.
