Skip navigation
Contact Us
899 Views 1 Reply Latest reply: Nov 7, 2012 8:50 PM by sasi ramesh RSS
varun kumar Novice 53 posts since
Aug 28, 2012
Currently Being Moderated

Nov 7, 2012 7:43 PM

New Lookup Port using from dynamic lookup to insert or Update

Hi, I am using dynamic lookup  to avoid the duplicates from source, thats fine,  my question is   i am using  dynamic lookup and lookup condition is  Sourcetable.Column(A) =  Lookuptable.Column(X)  then i know when we use dynamic lookup cache  then  New Lookup Port will be showed up  now i want to use condition for insert or update   when i take normal lookup  i use as follows

IIF(ISNULL(X),DD_INSERT,DD_UPDATE)  in Update strategy T/F

( Or )

  i take router and divide two groups one for insert and other for update

for insert group i give condition as  IIF(ISNULL(X),TRUE,FALSE), for update group  IIF(NOT ISNULL(X),TRUE,FALSE)

 

Now i wanna implement same  with this NEW LOOKUP PORT , i am confused with 0,1,2  conditions

 

we take lookup condition on one source column  and one from lookup table  so how this  NEW LOOKUP PORT  is linked to that comparision  and what to write to insert and what to write for update , please let me know

 

Thanks

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points