topic Re: Prepare tmap column values into oracle row insert query values in Talend Studio

Prepare tmap column values into oracle row insert query values

vidya821 — Thu, 21 Jun 2018 15:39:31 GMT

Hi,

Is there any component which might help to prepare data from tmap component to be used in toracleRow component.

E.g

tmap values with two columns

A|B

1|2

tOracleRow needs the values to be inserted as

('1','2')

Thanks

Vidya

Re: Prepare tmap column values into oracle row insert query values

fdenis — Thu, 21 Jun 2018 16:16:42 GMT

tRowGenerator

Re: Prepare tmap column values into oracle row insert query values

vidya821 — Tue, 26 Jun 2018 15:58:05 GMT

Hi Fracis,
Can you please elaborate as we cannot give the output of an excel file or tmap component to row generator.
Thanks
Vidya

Re: Prepare tmap column values into oracle row insert query values

Anonymous — Tue, 26 Jun 2018 16:11:36 GMT

Hi Vidya,

Can you please share a screenshot of what you have got already?

To get my self clear on what you want, you have a tmap's output connected to and toraclerow and would like to insert 1 and 2 values into column A and B?

Am I right?

If I am not right please explain.

Cheers!

Gatha

Re: Prepare tmap column values into oracle row insert query values

manodwhb — Wed, 27 Jun 2018 05:18:30 GMT

@vidya821,if you are sure that tMap having column A and column B with values like 1 and 2 then you can use below expression in tmap.

"('"+row2.A+"'"+","+"'"+row2.B+"')"

Re: Prepare tmap column values into oracle row insert query values

fdenis — Wed, 27 Jun 2018 08:14:25 GMT

trowgwnwrator is a row generator you if you configure it well you may have one row with two column 1,2. then insert this row in a tmap or directly in toracleoutput.

Re: Prepare tmap column values into oracle row insert query values

vidya821 — Wed, 27 Jun 2018 08:37:22 GMT

Thanks @gatha_vdm/@manodwhb
I have different data files with diffenent schémas to be inserted into oracle db,So i dont have defined shcema in tMap also.
The solution i am eyeing is whatever changes happens to no of columns, i shud be able to generate a insertable db row.
(This can be done via Java code, however i am looking if there is any component that can do the job 🙂 )
Thanks
Vidya