In source side ods_employess table,we select the employee_id,type_code both columns mapping single column (employee_id) in target table with any expression or function.if want two columns use the any function or one-to-one column map.
I want a one-one mapping. Issue is if and when I make any mistakes like I drag and drop one column over two other columns then how to correct that.
In this case, click on the target column and check the Properties window.
This way you'll be able to setup the correct source column.