Best practice to join data from 2 sources

somersst — Sat, 16 Nov 2024 02:25:15 GMT

Hi,

I start from source A for example customer. (for example 100 customers)

Now I have 2 sources B & C that can have address-info for this customer. (they don't have necessary info for these 100 customers)

I created 2 maps :

I do a lookup to address-info in source B. (outer join)

Next I do a lookup in source C. (outer join)

Now when the second lookup in Source C doesn't have a value, it still needs to use the value of source B.

When you make use of an outer join and you map the address info of source C and it doesn't have a value, you unfortunateley get a null value. I know you can make use of a formula to check if null, but if it's about a lot of fields this is considerable work. So I was wondering if there was an easier way.

Re: Best practice to join data from 2 sources

manodwhb — Mon, 18 May 2020 04:49:45 GMT

@somersst, the answer is you need to write manually, I do not think the easy way.

topic Re: Best practice to join data from 2 sources in Talend Studio

Best practice to join data from 2 sources

Re: Best practice to join data from 2 sources