connected and unconnected lookups?
- 4 Answers
- 7259 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 |
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is A cache?
What are multi-group transformations?
How might you approve all mappings in the archive all the while?
In joiner, how to load Master table in Target?
What do you understand by SOA of Informatica?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Why use shortcuts(Instead of making copies).
what is the difference between copy object import objects using repositery manager which one is best
Teradata 
