@INESBKwrote: Thanks for your replay. The issues are : -Table 1(tmssqlInput1) contains data since 2018 and Table 2 (tmssqlInput2) contains data from 2017. The expected result is to have the join of the 2 tables (data since 2017 and 2018) by name but I got only the value from the table 1. -In the screenshot, the number of lines inserted is 182753 while in the table it has only 400 line! Possibility1 : You seem to want an inner join (the default for tMap is left outer) Solution: If yes, change to inner: https://community.talend.com/t5/Design-and-Development/Doing-an-inner-join-using-a-tMap-component/ta-p/21572 Possibility 2: You seem to want to catch rejects, so you can see count? If yes, catch rejects (same link), so you can see how many has a.name <>b.name Possibility 3: If you want data for both 2017+2018, are you using English word "join" to mean rdbms word "UNION"? If yes, perhaps you've to find a way to "UNION"
... View more
I need to call a web-service (looks like a special web service, of some compaque_nsk_oss, I have no control over upgrading/changing that WS). The wsdl of that webservice looks like this: wsdl of DummyPinService I could call the “DummyPinService” using soapUI It has sections <soapenv:Header> and <soapenv:Body> Soap ui could get the response: SoapUI call works great Expt1: tESBConsumer using tXmlMap for payload fails. Looks like the tXmlMap is not providing Headers to ESBConsumer . Repository metadata was used for soapRequest. Error: Error Unmarshalling Request. tESBConsumer - payload - ErrorUnmarshallingRequest Also tried .. Expt2: Create tXmlMap-payload + tXmlMap-header = tMap_request -> tESBConsumer Observation: <Header> section seems correct . I do not see <Envelop>, <Body> in the logged request. Error : Error Unmarshalling Request. Header+Payload -> ErrorUnmarshallingRequest What should I do to get the same effect as payload supplied to soapUI? <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:compaq_nsk_oss_SoapHeader" xmlns:urn1="urn:cpq_tns_ODINITS-RETRIEVE-DUMMYPIN">
</soapenv:Envelope> Thanks Espresso
... View more