Query is like select a.pos, b.MATL_TYPE, b.MKTG_CATG,c.DMA, c.DIVISION

From pos a

Inner join material b on a.Material=b.Material

JOIN Customer c ON a.Customer=c.Customer

Now changes happening in customer and material. How should I bring changes...

newer files are accurate but it comes with overlap data.

might have to add extra column when loading data to staging table

These files are in same format and in same folder. Going to create staging table to get date range.