I have a table with two columns.
Table Name - PROGRAMS.
Columns - Pgm_ID, Pgm_Type.
What I am trying to accomplish is when I add a new row, I want to keep updating this table. But if the same Pgm_Type already exists, to ignore it.
In my model I assigned this table as SCD OLAP type. Column Pgm_ID as surrogate Key, and Pgm_Type as Add row on change. In my procedure insert statement I added 3 additional rows, but I am getting a primary key violation. Is it possible to do this without adding additional columns for Current record flag and start and end time stamp etc., Is there any alternate way to handle this.