Prepare tmap column values into oracle row insert query values

[vidya821]

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

[fdenis]

tRowGenerator

[vidya821]

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

[Anonymous]

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

[manodwhb]

@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+"')"

[fdenis]

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.

[vidya821]

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