topic joining two tjavarow in Talend Studio

joining two tjavarow

Anonymous — Tue, 14 Jun 2016 11:30:50 GMT

Hello,
I have two tJavaRow component in the same job and want to join them using the common key between them. But either tMap or tJoin accepting only one "Main input" and one "Reference input". In my case both are "Main output". How can I make join between them? Please help. it is bit urgent.

Thanks
Bala

Re: joining two tjavarow

Anonymous — Tue, 14 Jun 2016 12:11:57 GMT

I'm not sure you're explaining your issue.
You can connect two outputs to tMap.
One of these is considered a 'lookup'.
You can, within tMap, define your join model.
It's a similar deal with tJoin.

Re: joining two tjavarow

Anonymous — Tue, 14 Jun 2016 12:30:42 GMT

thanks much for the response. Here is my requirement. I am reading multi schema positional and processing them using the tJavaRow. After that I need to join them using the common field which is available in all schemas. thanks

Re: joining two tjavarow

Anonymous — Tue, 14 Jun 2016 14:43:21 GMT

You cannot re-join your data, once you've split it from a single source.
You'll need to drop the data in to a tHashOutput or tFile... so that you can re-read it.

Re: joining two tjavarow

Anonymous — Tue, 14 Jun 2016 15:15:31 GMT

I don't think tHashOuput is an option since my input file size more than 10 GB. Do you think of any other possibilities without splitting the record? Basically I would need to do the data validation here. Also the other issue is I have a time constraint like it has to be processed with in a hour. So putting to file and reading may not match with time constraint. Please guide me. thanks

Re: joining two tjavarow

ATeixeira — Tue, 01 Dec 2020 23:38:53 GMT

Did you find a solution?

I think i have the same problem.