Combining multiple tables and passing them into multiple tables based on conditions

[Vandy]

Hi team,

I am new to talend, it would be great if someone could guide me n how to create a talend job for the following to achieve the needs.

1. Combine multiple tables using tmap, output needs to be passed to multiple tables based on conditions. Filter to be created in tmap
2. Create user defined function and use that in tmap
3. enable store temp table option in tmap

Thanks in advance

[Anonymous]

Hello,

With your question 1 and 2, could you please elaborate your case with an example with input and expected output values? In this way, we could create a demo job for you.

You are able to enable store temp table option in tmap via selecting Store temp data option as true

For more information please refer to this KB article:

https://community.talend.com/s/article/OutOfMemory-Exception-WmtmQ?language=en_US

Hope these KB articles will be helpful for your tMap job.

https://community.talend.com/s/article/Best-Way-to-use-TMAP-component?language=en_US

https://community.talend.com/s/article/tMap-expression-syntax-TCiHW?language=en_US

Best regards

Sabrina

[dilip_n]

hi there, this might be the answers you want

multiple inputs linking to tmap main and lookup

click on tmap, here we can create multiple outputs in rightside(also we can use filter conditions and functions in expression builder) (use joins if you want in left side tables)by using routines we can create user defined function if you know java code well.

right click on tMap-->settings--> you can give store temp path

[Vandy]

Thank you @Dilipkumar nagala​ 

[Vandy]

Thank you for your inputs @xdshi