top button
Flag Notify
Site Registration

What is the difference between Connected and UnConnected Lookup Transformation.Give one or two examples?

+2 votes
434 views
What is the difference between Connected and UnConnected Lookup Transformation.Give one or two examples?
posted Sep 21, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

Connected Unconnected


1.With Pipe line Without Pipe line

2.Return Multiple Port Return Single Port

answer Sep 22, 2015 by Manikandan J
Similar Questions
+1 vote

What are the differences between Connected and Unconnected Lookup?

+2 votes

In unconnected lookup, what are the other transformations that can be used in place of that expression transformation?

+1 vote

When you create a Lookup transformation using a relational table as a lookup source, you can connect to the lookup source using ODBC and import the table definition as the structure for the Lookup transformation.
where as When you create a Lookup transformation using a flat file as a lookup source, select a flat file definition in the repository or import the source when you create the transformation. When you import a flat file lookup source, the Designer invokes the Flat File Wizard.

I found an interesting article on this topic at below links , It quite descriptive

http://www.tecktricks.com/difference-between-relational-lookup-and-flat-file-lookup-transformation-in-informatica/

...