Interested to Buy Any Domain ? << Click Here >> for more details...
connected and unconnected lookups?
- 4 Answers
- 8565 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hariom sharma
Connect lookup returns multiple columns for same whereas
UnConnect Lookup has only one out put port for each rows
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / sai suresh
Connected lookup is participats in Mapping level and it
will takes multipul inputs and provides multipul outputs.\
Unconnected lookup is does't participats in Mapping level
and it will takes multipul inputs and provied single output
only
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rekha
CONNECT LOOKUP IT INVOVES IN A MAPPING PIPELINE. IT
RECEIVES MULTIPLE INPUTS AND PROVIDES NULTIPLE OUTPUT.
SUPPORTS USER DEFINED VALUES
DYNAMIC CACHE
UNCONNECTED: IT DOES NOT INVOLVE IN A MAPPING PIPELINE. IT
IS CONNECTED FROM THE RESULT OF :LKP() EXPRESSION IN
ANOTHER TRANSFORMATION
IT RECEIVES MULTIPLE INPUTS AND PROVIDE A SINGLE OUTPUT
THAT IS RETURN PORT
IT DOES NOT SUPPORT USER DEFINED VALUES
STATIC CACHE
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / viresh
Unconnected lookup can use multiple time in expression for
fetching different values from lookup table.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is update strategy transform?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
what is the difference between stop and abort?
If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?
How can we update a record in the target table without using update strategy?
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
without table how to come first record only in oracle?
how to identify new and old values in source qualifier or any other transformations using informatica
how to get the data from the client machine and how to get server location data to client loction can any body explain to me
If informatica has its scheduler why using third party scheduler?
write s sql query following table some duplicate present i want unique one column duplicate another column display? name id a 1 a 1 b 2 b 2 c 3 i want the required output like unique duplicate name id name id a 1 a 1 b 2 b 2 c 3
Teradata 
