topic Combining multiple tXMLMap output values to a single snowflake table in Talend Studio

Combining multiple tXMLMap output values to a single snowflake table

vvazza10 — Sat, 16 Nov 2024 00:19:37 GMT

Hi ! I have the below XML structure as input

</companyinfo>

</header>

</response>

</electrical>

</response>

</mechanical>

</response>

</chemical>

The output that i am expecting is

Company ID | Company name | Dept | Dept ID | Total emp

100 | ABC Corp | Electrical | 1 | 200

100 | ABC Corp | Mechanical | 2 | 150

100 | ABC Corp | Chemical | 3 | 100

The job design that i tried was

tFileInputXML -> tXMLMap -> tUnite -> tDBRow

How to combine outputs from deptinfo_electrical, deptinfo_mechanical, deptinfo_chemical to tUnite to have them all loaded to one single snowflake table?

Re: Combining multiple tXMLMap output values to a single snowflake table

tnewbie — Mon, 05 Apr 2021 22:08:00 GMT

Your ask will kind of defeat the purpose of XML, but to answer your question, Your best bet can be to have repeated instances of same target table, which means you will have 4 different pipe lines, each pipelines going to a target definition, but each of these target definitions will point to the same table.

Re: Combining multiple tXMLMap output values to a single snowflake table

vvazza10 — Thu, 08 Apr 2021 13:33:28 GMT

Thank you ! This is the approach I have decided to test with. Would it be possible to set up a generic job that will load a particular table by executing a particular part in tXMLMap based on parameter that was passed from the parent job?

Say I setup few tRunJob components that will take different Context param. The first tRunJob has context param as deptinfo and target table name as deptinfo_sf, and based on what parameter was set, I would want deptinfo in tXMLMap to get executed and load the target snowflake table. Is this achievable?