What are the types of Lookup transformations in informatica MDM?
Posted by Support@InventModel.com Posted by Aug 21, 2023 in Informatica Powercenter Commonly Asked Questions Answers
What are the types of Lookup transformations in informatica MDM?
There are four different types of lookup transforms used in informatica PowerCenter.
Relational or Flat-File Lookup: Perform searches on relational tables.
Pipeline Lookup: Performs a search of application sources.
Connected or Unconnected Lookup: While the Connected lookup transformation receives data from the source, performs the search, and returns the results to the pipeline, the disconnected search runs when the source is disconnected. Returns the columns to the calling transformation.
Cached or Uncached lookup: You can configure the Lookup transformation to cache search data or directly query the search source when invoking search.