Five Stars

How to get data from multiple tinputs into single toracleoutput in Talend

1.Input is-toracleinput_1 2.Input is-toracleinput_2

Now I want to use tmap for data process and then load these 2 input into Single toracleoutput.

How to do this

 

 

10 REPLIES
Twelve Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

Do these inputs have the same schema? If yes, you can use a tUnite to merge the data. If they have different schemas, first receive the data from each, modify the schemas, then use a tUnite. After the tUnite you can pass the data to the tMap and out to your output. 

Rilhia Solutions
Five Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

Yes both are same schema. If I use tunite, 1st Input is Main connection but 2nd input not get connected to tunite. How its>?

Twelve Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

 

You should be able to connect both your inputs to it. Like below....

 

merge.png

Rilhia Solutions
Five Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

My 2 inputs are tA400 Input. But I can't connect 2nd  input to tunite.

 

 

Twelve Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

Can you take a screenshot and post it here to show me?

Rilhia Solutions
Five Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

fdffdd.png

Twelve Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

What happends when you right click, select "Row", then "Main" and drag the link to the tUnite component? This should work. Are you doing anything other than the above on both your inputs?

Rilhia Solutions
Five Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

When I Try to link its stopped , no this is my start of the job.

Five Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

Moreover, I have manual query for both but same schema. using alias in query

Twelve Stars

Re: How to get data from multiple tinputs into single toracleoutput in Talend

The type of query should make no difference. Try deleting the component that will not connect and add it again. This should just connect. Something is not working properly. This is *sometimes* a symptom of needing to restart your Studio.

Rilhia Solutions