joining two tjavarow

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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.

[Anonymous]

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 

[ATeixeira]

Did you find a solution?

I think i have the same problem.