topic Re: Transform one row in two rows in Talend Studio

Transform one row in two rows

JMartinezB — Sat, 16 Nov 2024 01:55:06 GMT

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?

Re: Transform one row in two rows

vboppudi — Mon, 13 Jul 2020 19:33:17 GMT

Please provide some source sample data and expected results.

Regards,

Veeru

Re: Transform one row in two rows

JMartinezB — Mon, 13 Jul 2020 20:05:29 GMT

Per each row bussiness:

Re: Transform one row in two rows

manodwhb — Tue, 14 Jul 2020 08:16:28 GMT

@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.

Re: Transform one row in two rows

JMartinezB — Tue, 14 Jul 2020 13:13:09 GMT

@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.