I'm running into an issue, when I update 1 of the source records, it outputs all of them for the PK_HubContract id which I've done the update on.
This is what my job is doing: If a source record not in the lookup tables then insert, else update row6 lookup table based on the output filter for copyofExpirteRows_0 and insert the new updated record based on the output filter for copyofUpdatedInserts_0.
I only updated the source record PK_HubContract = 2 Probability to 0.75 and I'm getting all of the
4 records and 3 of them which were not updated.
[statistics] connecting to socket on port 3458 [statistics] connected .--------------+----------------------------. | tLogRow_5 | |=-------------+---------------------------=| |PK_HubContract|LEDTS | |=-------------+---------------------------=| |1 |Fri Jun 22 11:03:18 CDT 2018| |2 |Fri Jun 22 11:03:18 CDT 2018|---->Only this record should output |3 |Fri Jun 22 11:03:18 CDT 2018| |4 |Fri Jun 22 11:03:18 CDT 2018| '--------------+----------------------------'
My filter should be this, (row4.OpportunityId = row5.OpportunityId and row4.ContractNumber = row5.ContractNumber and row5.PK_HubContract = row6.PK_HubContract) && row6.LEDTS is null
and (row4.statusid <> row6.statusid or row4.probability <> row6.probability or row4.Deleted <> row6.Deleted)