Handling mutli-value columns in ODI

Tools & Utilities

Handling mutli-value columns in ODI

Could anybody please tell me whether we have any built-in functionality for handling mutli-value columns in ODI (Oracle Data Integrator)? 

I mean, can we transform a multi-value column row to 3rd normal form (splitting it into multiple rows)?

For Example Following row has multi-value field Phone_Number.

CustomerID FirstName LastName Phone Numbers

111 Joe Smith 123-456-1111$123-456-2222$123-456-3333


This needs to be split like,

CustomerID FirstName LastName Phone Numbers

111 Joe Smith 123-456-1111

111  Joe  Smith 123-456-2222

111  Joe  Smith 123-456-3333

Regards,

Kashif