You can simply create a mapping with multiple target tables and map the columns as required. For the phone numbers, you can use the merge tx to place them all in a single field.
Thanks for the reply. In Table 4, phone numbers are concatenated (Phone1, Phone2, Phone3) if we use the merge tx, rather in sequential. I want the output to be in sequential order as I mentioned above.
You can use a different separator for the records to add all the phone numbers in one column. You can share a sample input and expected output so that I can suggest you better.
Thanks for your response. Please find the attached input and expected output.