Interested to Buy Any Domain ? << Click Here >> for more details...
connected and unconnected lookups?
- 4 Answers
- 8615 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 are surrogate keys?
What is junk dimention?
Slowly changing dimensions, types and where will you use them
How can you recover the session in sequential batches?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
HOW TO YOU LOAD TIME DIMENSION
In update strategy target table or flat file which gives more performance ? why?
How to recover the standalone session?
In warehouses how many schemas are there?
without using rank transformation how can we rank items by using some other transformations
What are the restrictions of union transformation?
What is tracing level and what are the types of tracing level?
Teradata 
