Seven Stars

Prepare tmap column values into oracle row insert query values

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

6 REPLIES
Ten Stars

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

tRowGenerator

Francois Denis

Don't forget to tag when it's "solved"!

Seven Stars

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

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

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

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

Twelve Stars

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

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

Manohar B
Ten Stars

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

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.

Francois Denis

Don't forget to tag when it's "solved"!

Seven Stars

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

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