Hi
Moderators: chulett, rschirm, roy
-
mcs_suresh
- Participant
- Posts: 9
- Joined: Fri Sep 21, 2007 10:37 am
Hi
What is difference between a connected look up and unconnected look up?
-
pravin1581
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
Re: Hi
This pertains to Informatica.mcs_suresh wrote:What is difference between a connected look up and unconnected look up?
-
mcs_murali83
- Participant
- Posts: 23
- Joined: Sat Sep 29, 2007 6:05 am
- Location: Datastage
- Contact:
Hai
connected lookup will return more values and unconnected returns one value.
conn lookup is in the same pipeline of source and it will accept dynamic caching. Unconn lookup don't have that facility but in some special cases we can use Unconnected. if o/p of one lookup is going as i/p of another lookup this unconnected lookups are favourable.
If you are having defined source you can use connected, source is not well defined or from different database you can go for unconnected.
conn lookup is in the same pipeline of source and it will accept dynamic caching. Unconn lookup don't have that facility but in some special cases we can use Unconnected. if o/p of one lookup is going as i/p of another lookup this unconnected lookups are favourable.
If you are having defined source you can use connected, source is not well defined or from different database you can go for unconnected.
Murali
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: