Create an output based on 2 DBinputs

[thomas_2583]

Hi,

I have 2 databases and what I need is the following.

Database_One will have these fields:

acc_no

comp_id

td_number

comp_amount

acc_amount

Database_Two doesn't have all of the fields within Database_Once, just the following:

acc_no

comp_amount

acc_amount

What I want to do it take all of the fields within Database_One, join to Database_Two using acc_no and SUM the comp_amount and acc_amount from the 2 databases so the final output will have the following output:

acc_no

comp_id

td_number

comp_amount

acc_amount

Any idea how I could go about doing that please? I was thinking of having the 2 TDInputs to a TMap which then goes to a TDOutput, but not sure if that's quite right.

[Anonymous · Accepted solution]

Hello,

For your use case and requirement, this goal can be achieved by using tDBInput components and tMap component.

The workflow should be: tDBInput(Database_One)-->tMap-->tDBOutput

tDBInput(Database_two)

Here is a KB article about: https://community.talend.com/s/article/tMap-expression-syntax-TCiHW

Hope it helps.

Best regards

Sabrina

[Todd66]

you can use merge join or stream look up step if both input have key like comp_amount and acc_amount