topic One To Many problem in Talend Studio

One To Many problem

Anonymous — Mon, 11 Sep 2017 05:34:44 GMT

Hi all

I have 1 row in oracle DB i need to insert to Postgres tables 1 Partner 1-1 Partner address (home/work address)

In Partner table have 1-1 foreign key home_address/work_address

Get Addresses ids from sp ("select nextval('public.addr_seq') as workaddress_id"/"select nextval('public.addr_seq') as homeaddress_id") tpostgressinput(lakcim_id/levcim_id)

In the map i set this ids.

When i insert 2 Address and 1 Partner table show the next errormessage :

Zoltan

Re: One To Many problem

Sid3 — Mon, 11 Sep 2017 06:03:33 GMT

Split your job to two subjobs.

one to load CIM table and another one to load to partner table so that it will not violate the foreign key constraint.

Re: One To Many problem

Anonymous — Mon, 11 Sep 2017 06:49:27 GMT

Thanks,

I create two job ? Sorry i missing something in my workflow, please help me.

Job1

tOracleInput -> tMap->tPostgresOutput(Addr1)

->tPostgresOutput(Addr2)

Job2

tOracleInput -> tMap->tPostgresOutput(Partner)

Job1-onSubJobOk>Job2

my question is how to pass parameters??? (PartnerId for 1st tOracleinput, parameter Addr1-2 for Job2 Partner)

Thank you,

Zoltan

Re: One To Many problem

Sid3 — Wed, 13 Sep 2017 09:40:32 GMT

use globalMap.get() and globalMap.put() functions.

For example I am calculating a value Partnerid in subjob1. then I should put in a global variable.

globalMap.put("partnered",row1.partnerid)

in second subjob you can call this variable using below function.
if the variable is string
(String) globalMap.get("partnered")

let me know if this helps