Hi All,
There is a requirement for me to split a record from Source into two rows and insert into destination as mentioned below. Kindly let me know, which will be the best approach to handle this.
Source:
Location | Tool Number | Date | Run Hours | REC_ID | MCHN_NO |
605 | 5047836/5047837 | 9/10/15 1:37 | 0.2 | 14013 | 945 |
Destination:
Location | Tool Number | Date | Run Hours | REC_ID | MCHN_NO |
605 | 5047836 | 9/10/15 1:37 | 0.2 | 14013 | 945 |
605 | 5047837 | 9/10/15 1:37 | 0.2 | 14013 | 945 |