connected and unconnected lookups?
- 4 Answers
- 7291 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 DR strategy for Informatica project?
What is the difference between normal and bulk loading? Which one is recommended?
What is union transformation in informatica?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
Separate from an archive server and a powerhouse?
why we use datawarehouse
What is status code in informatica?
What is the Hierarchy of DWH?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Can we update the data in flat file using update strategy?
Teradata 
