Hi!
First off, I wanted to say what an amazing application Talend Open Studio is! It's unbelievable that it's an open source project. Well done to everyone involved!
I had a wee question that I hope someone could help me with:
My input data source, representing a contact, has two phone numbers in a single row: Home, Mobile
My output data source stores phone numbers is a separate table, with one row for each type, linking each back to the contact. Therefore, one row in source goes to two rows in target.
How do I configure the tMap component to map the two columns from the single source row, into two rows in the target schema? There's a type field in the target schema that I'd also like to populate with 'Home' or 'Mobile', depending on which source column goes into that row.
For context, if it helps, I've just started looking at this application to assist in data migration using the Siebel CRM software from Oracle. It looks like this is the perfect tool for populating EIM tables from source data of all types, enabling us to get it into the Siebel database. We've been using SQL Loader and Access (!) so far and it's proving to be a nightmare to run and maintain.
I hope this makes sense and isn't a complete nube question. You help is very much appreciated!
Kind regards,
mroshaw