topic Re: Combining multiple tables and passing them into multiple tables based on conditions in Talend Studio

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

Vandy — Fri, 15 Nov 2024 21:52:56 GMT

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.

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

Thanks in advance

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

Anonymous — Fri, 21 Apr 2023 07:25:56 GMT

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

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

dilip_n — Fri, 21 Apr 2023 09:45:28 GMT

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

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

Vandy — Tue, 02 May 2023 11:52:39 GMT

Thank you @Dilipkumar nagala

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

Vandy — Tue, 02 May 2023 11:54:33 GMT

Thank you for your inputs @xdshi