difference between connected and unconnected lookup in informatica

on

 difference between connected and unconnected lookup in informatica?




connected lookup                                                                       unconnected lookup

  • part of dataflow                                                     it is separated from dataflow
  • static cache and dynamic cache                             only static cache
  • it will return multiple ports                                    it will return only one port by checking R port
  • more readable                                                         less readable
  • for every record lookup will execute                    only executes when lookup function is called

Comments

Post a Comment