What is the use of a Lookup transformation

sadat mahra

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ben Martin5y ago
The Lookup transformation is used to look up a source, source qualifier, or target to get the relevant data. You can look up the flat file and relational tables. The Lookup transformation in Informatica works on similar lines as the joiner, with a few differences. For example, lookup does not require two sources. Lookup transformations can be connected and unconnected. They extract the data from the lookup table or file based on the lookup condition.
The lookup transformation is created with following type of ports
Input port (I)
Output port (O)
Look up Ports (L)
Return Port (R)
The lookup transformation supports horizontal merging such as equijoin and nonequijoin.

I hope this is helpful
Ben Martin

+1
Mageshwaran R6y ago
Hi Mahra,

https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/lookup-transformation#:~:text=For%20example%2C%20the%20Lookup%20transformation,be%20added%20to%20new%20columns.
+2
Guest User6y ago
Query change is utilized for performing queries by joining information in input segments with segments in the reference dataset. The reference table can be another table or a current table, see, or the SQL result inquiry result.
0