What is diff between connected and unconnected lookup?
Answer Posted / naidu.k
Connected Lookup
Its can recieve multiple input ports and returns
multiplepoutputorts
it is part of mapping data flow
when lookup condition no match Data the integration services
returns insert the data
when lookup condition match Data The integration services
returns update the Data
default values supports
UNConnected Lookup
Its not part of mapping data flow it can recieve multiple
input ports and return single output ports.
when lookup condition no match data the integration services
returns null values
when lookup condition matchdata the integration srvices
returns update data
default values removed
I
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the mapping parameters and mapping variables?
What is an Integration service in Informatica?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Define update strategy?
What are the advantages of informatica?
Explain what are the different types of transformation available in informatica.
What is the Rank index port in Rank transformation?
What is powercenter on grid?
Where are the source flat files kept before running the session?
What if the source is a flat-file?
can we override a native sql query within informatica? How do we do it?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
How can we use mapping variables in informatica?
What are the main features of Oracle 8i with context to datawarehouse?
What are the types of caches in lookup?