Please subscribe on my YouTube Channel.
Requirement: Match all the incoming value columns from the source to the corresponding column value in the reference table,
if the match is found get the value if no match then insert.
Requirement: Match all the incoming value columns from the source to the corresponding column value in the reference table,
if the match is found get the value if no match then insert.
You need the Newlookuprow port to check what has happened in the cache.
You will use an Update strategy after the lookup with the dynamic cache.
If the value in the NewLookupRow port is 1, you need to set the record to DD_INSERT,
if it's 2 set it to DD_UPDATE.
if it's 0, you either set it to DD_REJECT or you use a router to route it to somewhere else.
The Associated Expression needs to have ports that you want to compare the lookup port with, otherwise, we wouldn't know what to insert/update in the cache.
Join condition ports are ignored in comparison. Also, you can ignore columns which you know will be changing like timestamp or date column.
No comments:
Post a Comment