I have a weird situation, where one my application team asks us to add a column to an existing table, the new column will get populated after 2 months. Until two months they want to keep the values to Null, after which they shall load the data into table which will be unique, they are asking if we can declare this column as USI ?
My answer was "No" want to see if someone has any work around ?
No is the correct answer, (unique violation). why not just build the USI after the data has been populated in 2 months?