top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

+2 votes
128 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 Google+ Share Button LinkedIn Share Button Multiple Social 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/

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...