Interested to Buy Any Domain ? << Click Here >> for more details...
connected and unconnected lookups?
- 4 Answers
- 8776 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 a surrogate key?Why we use it in a mapping?Pl give an example.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
In operator is used in which transformation in informatica 8.6.0
why we need informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
What are Dimensions and various types of Dimensions?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
how u know when to use a static cache and dynamic cache in lookup transformation.
What is workflow? What are the components of the workflow manager?
what is mystery dimension?
Explain the features of connected and unconnected lookup.
Teradata 
