I want to split data in to two target according to sal. If the sal is higher then 20000 then it should go in the first table and if it is less then it then it should go in to the other table.
For that I need to write procedure or I can write transformation? If it can be done by transformation then at which level I have to define that?