You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » [resolved] Problem with tmap having multiple inner joins (order)
Post a reply
Topic review (newest first)
- mpa
- 2011-09-02 15:12:11
Thanks for all your input.
I will change my job to work with only one ouput using left outer joins and not with an inner join and two outputs.
Regards
- alevy
- 2011-09-02 09:52:31
That is how Talend works for efficiency: once one inner-join fails, it does not bother to attempt any remaining joins.
If you need to know all the failed joins, then as janhess suggested, you need to use left-joins and have an output filter instead.
- janhess
- 2011-09-01 18:08:24
Or you could just uncheck the inner join in the tMap on the input joins.
- mpa
- 2011-09-01 16:54:02
Bagpuss,
So you are saying that I should use 3 different tMaps / tJoins to do this?
Isn't there another possibility?
Thanks in advance,
Regards
- Bagpuss
- 2011-09-01 14:29:32
If you are diong a straight forward lookup of client code to the client table to return the client id, I'd use tJoin, so in your case, use 3 tJoins.
Failing that, split into 3 tMaps, that way you'll know exactly which inner join failed. Where you catch you inner join failures, always include a failed component/datetime which you can poplulate.
- mpa
- 2011-09-01 13:32:51
Hi,
I'm facing a problem with the tMap component in one of my jobs.
So for my Sales job where i'm uploading Sales data i'm having a tMap component that has multiple joins to my dimensions (customers / product groups / company) to look if it is an existing customer/product groups/etc..
So in my tMap I have:
Main flow: Sales
Lookup1: Company
Lookup2: Customers
Lookup3: Product groups
The problem is that when the first or the second lookup fails all the next lookups fail aswell. So if for example a sales record has an unknown customer it also says that the product group is unkown. If the company is unknown, both other lookups fail.
Does anyone know why this is happening? Since the joins aren't connected with each other but it's always a join between Sales and one of the lookups.
Any thoughts would be appreciated,
Thanks in advance,
Regards,