top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+2 votes
534 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?

What are the differences between Connected and Unconnected Lookup?

+2 votes
Informatica: In unconnected lookup what are other transformations that can be used in place of expression transformation

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

+1 vote
What are Difference between Relational Lookup and Flat File Lookup Transformation?

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/

...