I have a source and several lookups and am using tmap to do the comparison.
How do you do <> comparison between source and lookups?
Source = orderdetail
lookup = itemdesc
This is an example of a query:
select count(*) from orderdetail a,
where a.itemnbr <> b.itemnbr
Make the inner join rejects true.
If I have 1 source and 3 lookups and need to grab few fields from lookup1, lookup2,lookup3 and source. Do you have an example you can show me? This will be <> comparison between all.
I'm really new with Talend and trying to figure out how we can do this in tmap.
Have source and 2 lookups
source.id = lookup1.id and lookup2.Lastupdateddate is Null and
(source.field1<>lookup2.field1 or source.field2<>lookup2.field2)
if criteria matches, then expire lookup2 record set lastupddateddate = currentdatetime.
if record doesn't exist then insert a new record.
if possible, share all source file with me and I will let you know how to get your expected result,
When a new id is added in the source table, it doesn't insert.
1. Ran the job with no records in the lookup table.
2. It inserted new records in the lookup table
3. Added another id in source which doesn't exist in the lookup table.
4. Reran the job and it doesn't insert the new id.
What should I change in tmap?
My source is coming out of sql db. I've created dummy tables and records.
create table testsource
insert into testsource
create table testlookup1
insert into testlookup1
create table testlookup2
insert into testlookup2
values(100,'item1','1 chair','2018-06-17 13:37:08.347')
(101,'item2','1 sofa','2018-06-17 13:37:08.347')
(101,'item2','2 sofas','2018-06-18 08:31:00.000')