tMap one to many mapping

[Anonymous]

Hi ,
Can anybody tell me what is the problem with the below mapping.There is a one to many mapping between these two tables ie for a FacilityId I can have more than one Ratings,but by this mapping Iam getting only one Rating (ratingtypecode,ratingvalue) in my output

[Anonymous]

If the size of your data isn't too large, then I'd suggest using the "hidden" components tArray and tArrayIn (please search the forum for information on these). You can then do the whole job "in memory".

I searched but did not find an detailed example for the tArrayIn usage with Java.
But what I found was https://community.talend.com/t5/Design-and-Development/Check-for-alternate-records-in-a-file/td-p/96... with an error message I?m able to reproduce.
Any suggestion on the correct usage of tArrayIn (for Java)?

[c0utta]

Hi Vaiko,
I create Perl jobs, so I can't comment on the Java implementation. Nonetheless, I created the equivalent job in Java that demonstrates the basic use of tArray and tArrayIn and it fails with

Exception in component tArrayIn_1
java.lang.ClassCastException: p2069.p1602.p1602$row1Struct cannot be cast to p2069.p1602.p1602$ThenRunStructarray_tArray_1
	at p2069.p1602.p1602.tArrayIn_1Process(p1602.java:155)
	at p2069.p1602.p1602.tRowGenerator_1Process(p1602.java:361)
	at p2069.p1602.p1602.runJob(p1602.java:447)
	at p2069.p1602.p1602.main(p1602.java:383)

I would create an entry in the bug tracker if you want this resolved. I reported the same (or similar) bug for Perl with http://talendforge.org/bugs/view.php?id=2431
Cheers,
c0utta

[Anonymous]

Hi amaumont

Use ThenRun connection to process your job in two steps.

Can you please explain me in detail as Iam new to this tool..Is the mapping which i did correct ???,if yes where should i use ThenRun.If possible pls send me a screen shot
Thanks
Syed Abrar

[Anonymous]

Even tried this way ..still not able to map

[amaumont]

In the joined schreenshot, you can see a job where intermediate data (DATES_MATCHES and ALL_BEFORE_DATES) is written in a first step and read in a second step (up to bottom) to find final results (tLogRow).