Test cases for ETL column update
We have a table in which value of one column (EMP_CD) is updated from '~' to 1 for some selected records(based on filter conditions).
Now, I am wondering what can be the test cases for this scenario. So far I figured out the following two -
1. All the records meeting selection criteria should have EMP_CD=1
2. All the records which don't meet selection criteria should have EMP_CD = EMP_CD of Backup( before update table)
Any other things which I should test for this scenario? Looking forward to help.