Hello, I have table called sales having fields Invoice Number,OrderCategory,Item.Its a incremental load table. Everyday day-1 data from source gets added to this table.
Currently I had to add InvoiceDate column to table.
Now I need to load this column data for all the previous record as well.
There is no single column with unique value, can say unique combination would be Invoice Number,OrderCategory,Item
Please suggest best possible way to load invoice date column.