Forum Discussion

pranil2k2's avatar
pranil2k2
Contributor
6 years ago

Insert/Update using Join Snap

Hi, I am using Join Snap, to implement the logic of Insert new record and update existing one by doing join on target table. i defined left outer join to read all input records and in router i used...
pranil2k2's avatar
pranil2k2
Contributor
6 years ago

Hi,

Thanks for the information. Two thing I want to ask you for advice.

  1. I went through Diff Snap, can I know whether it will use any key column to compare between two files?
  2. this is regarding Join Snap, what is the use of Left Outer Join? if i cant differentiate new and old records? the inner join will give only matched records, the left outer join has to give both matched and new recrods right? then it will be easy to do insert/update.

Thanks in advance.

Anil

RogerSramkoski's avatar
RogerSramkoski
Employee
6 years ago

Hello Anil,

The Diff snap looks at the entire record for comparison, not a single key. The documentation linked in the previous reply has sample pipelines to download then import, which can help you understand how the snap will function.

Regarding your second question, left outer join will take all the data from input0 and input1 that did not match. Our Join snap documentation has an example of what a data stream looks like for each join type.