What is diff between connected and unconnected lookup?
Answer Posted / ramesh
the main difference between connected and unconnected is
connected:
recieves data from source table in a pipeline.
it returns multiple columns
it supports user defined default values
unconnected:
recieves data from result of the lookup expresion on other transformation
it returns one column
it doesnt supports use defined default values
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Under what condition selecting sorted input in aggregator may fail the session?
can we override a native sql query within informatica? Where do we do it?
What are the different options available for update strategy?
How can repository reports be accessed without sql or other transformations?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Explain in detail scd type 2 through mapping.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is a router transformation?
How many number of sessions can one group in batches?
What is decode in informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What all are steps in up gradation of Informatica server?
How to join three sources using joiner? Explain though mapping flow.
What is the difference between source qualifier transformations source filter to filter transformation?