I am doing a data migration.. The source table has five columns...

C001_STILL 0
C001_MATTE 0
C001_ZERO_BLACK 0
C001_FULL_SCREEN 1
C001_LOWER_THIRD 0
C001_OTHER 0


The rules of migration is given below.....

Step 1: Check the value present in the column “C001_ANIMATION”, “C001_STILL”, “C001_MATTE”, “C001_ZERO_BLACK”, “C001_FULL_SCREEN”, “C001_LOWER_THIRD” and “C001_OTHER”

Step 2: Whichever column has value 1, insert those many records into table “RequestID” table.
In this case column “C001_ANIMATION” and “C001_FULL_SCREEN” has value “1”. Then insert two records into RequestID table.
Records in the table will look like as below,

Req ReqID TagID ReqDesc ReqSel Elem
643 1234 Blank. blank FALSE "Animation"
644 1234 Blank. blank FALSE "Full Screen"