I want to create a DB2 table which will have columns like Emp No, Seq No, Acct No, Rate, Hours Worked, etc. This table will be loaded monthly using an input file which will have Emp No, Seq No and Acct No same and other values getting changed/updated OR New Emp No, SeqNo being introduced.
I want to append the new data everytime it is loaded.
Please let me know how to come up with Key (Primary key) definitions along with the indexes for defining this table.
Can you please let me know some of the things that needs to be taken care when defining a table without primary key since the data needs to be appended every time. Also how to come uo with indexes for the same to improve the performance.