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.

Related Posts :

Aug 21, 2023

What are the types of Lookup transformations in informatica MDM?

What are the types of Lookup transformations in informatica MDM?There are four different types of lo...

Posted by Support@InventModel.com

Aug 25, 2023

Aggregator Transformation in Informatica PowerCenter

The Aggregator transformation is an active and connected transformation.The Aggregator transform is...

Posted by Admin-Lisa

Sep 08, 2023

Transformation in Designer Tools in Informatica Power Center (IPC)

Transformation in Designer Tools in Informatica Power CenterOverview of Transformation:Informatica T...

Posted by Admin-Lisa

Sep 12, 2023

Parallel processing in informatica PowerCenter

Parallel processing in informatica PowerCenterIn informatica PowerCenter parallel processing further...

Posted by Admin-Lisa