Problem with MINUS

One Star eng
One Star

Problem with MINUS

HI, I use TOS 2.1.1 - java
I?m trying for to create a minus.
There are 2 tables: A and B.
|A.NOME | B.NOME | A-B SQL |
|-----------+-----------+------------|
|(null) |MARIO | (null) | 1° case
|ROSSI | ROSSI | ________|
|A.NOME|B.NOME | A-B SQL |
|---------+---------+-----------|
|MARIO | (null) | MARIO | 2° case
|ROSSI | ROSSI | ________|
|A.NOME |B.NOME | A-B SQL |
|-----------+----------+------------|
|(null) | (null) | (empty) | 3° case
|ROSSI | ROSSI | ________|
|A.NOME|B.NOME| A-B SQL |
|---------+--------+-----------|
|ROSSI | (null) | (empty) | 4° case
| | ROSSI | _______ |
How can I have the same result using TOS?
I have tried with 2 tOracle inpmut and 1 tMap, but the results are different from SQL.
Thanks a lot Smiley Happy
One Star eng
One Star

Re: Problem with MINUS

The tMinus can be 'simulated' with an left outer join and a filter on the part that is not matched. Click on the inner join rejects button, on the output table.
I?ve resolved the problem reading this posts:
http://www.talendforge.org/forum/viewtopic.php?pid=3887#p3887
http://www.talendforge.org/bugs/view.php?id=424
ciao ciao Smiley Wink
One Star eng
One Star

Re: Problem with MINUS

With 2 tables there aren?t any problems, but with more table the results are wrongs!!
Hi, I use TOS 2.1.1 Java version,
and I try to reproduce a MINUS with 3 tables in TOS.
This is the oracle select:
select msg from log
minus
select msg from log2
minus
select cognome from paziente
I use 3 tOracleInput and 1 tMap.
I tried to 'simulated' the minus with an left outer join and a filter on the part that is not matched, but the result is wrong!!
There are my tables:
TABLE LOG
ciao
aaaa
CIAO
A1
TABLE LOG2
(null)
CIAO
CIAO2
TABLE PAZIETE
A1
(null)
rossi
The result of this MINUS in Oracle is:
-------------
ciao
aaaa
------------
Any idea?
Thanks to all Smiley Wink
Employee

Re: Problem with MINUS

Hello eng,
This MINUS problem is quite difficult to handle in TOS.
We have planned to develop all those DB functions in dedicated components.
In the interval, I think that the best thing to do is to put your request directly in your tOracleInput.
Regards,
Michaël.
One Star eng
One Star

Re: Problem with MINUS

Hello Michaël! Smiley Happy
Thanks for answer!
I find a ?little? solution. I?ve think to split the minus in more parts.
(A-B-C) = (A-B)-C
It runs Smiley Wink
Do you have some idea about the release plan ?
When version 2.1.2 will be released?
Thank you
Regards,
Marco
Employee

Re: Problem with MINUS

2.1.2 will be released next week.
About a release with tMinus, I really can't say anything yet.
Michaël.