Code: Select all
ODBC CONNECTOR(B)
|
ODBC CONNECTOR(A)--->LOOKUP1---> MATCHED1 ODBC CONNECTOR(B)
| | |
UNMATCHED1 FUNNEL1 --->LOOKUP3--->ODBC CONNECTOR(C)
| | |
ODBC CONNECTOR(B)-->LOOKUP2--> MATCHED2 UNMATCHED3
| |
UNMATCHED2 ----------->FUNNEL2--------> ODBC CONNECTOR(D)
I have a columns in A table with docnbr(2008 939030) and docnbr1(2008-939030) and Table B with jrnnbr(2008 939030) jrnnbr1(2008-939030) columns this is Or condition so I am doing lookup twice with LOOKUP1 and LOOKUP2.
LOOKUP1: docnbr=jrnnbr char(20) nullable Y=N
LOOKUP2: docnbr1=jrnnbr1 char(20) nullable Y=N
Some Values are not matching from LOOKUP1 and LOOKUP2.
LOOKUP3: Eiand=level char(255),char(2) nullable Y=Y
Here condition is Ereplace(Ereplace(link.Eiand,'oeiro','F',0,-1),(link.'kdojke','G',0,-1) and doing a lookup.
These 3 lookups are not matching for some values when comparing between A and B tables.
I have not enabled multiple rows returned from the link and partitioning is HASH on both links which is having same record count 4500.
I could see warning in logs as Ignoring for Recod 8,9 etc. May be this is because of duplicates? as my 3 Key fields contain duplicate values in both A and B tables.
Could anyone let me know how to solve this issue?