Transform one row in two rows

[JMartinezB]

Hi.

I am migrating data from a Oracle database to another.

With the new model, one row in one table becomes two dependent records in two tables.

That is, for each row in the table in the origin schema, multiple data is collected and an insert is performed in a table in the destination schema. The id of this insert (sequence) should be retrieve and used to make a second insert into a second table along with the rest of the data in the row of the source schema.

This is possible?

[vboppudi]

Please provide some source sample data and expected results.

Regards,

Veeru

[JMartinezB]

Per each row bussiness:

[manodwhb]

@Javier Martinez​, first load the address table and in the second job load new_business and while loading do do lookup with address table to get address_id.

[JMartinezB]

@Manohar B​ 

This isn't valid. The same address can be in several business, only the address_id differentiates them in a new_business. This is so that the address can be edited independently.