Interested to Buy Any Domain ? << Click Here >> for more details...
What is diff between connected and unconnected lookup?
- 5 Answers
- 8745 Views
- BirlaSoft, Blue Star Infotech, I also Faced
- E-Mail Answers
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
Enlist some properties of sessions.
What is an aggregator transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What are the designer tools for creating transformations?
Differentiate between source qualifier and filter transformation?
What are the reusable transformations?
can we override a native sql query within informatica? How do we do it?
What is status code in informatica?
what are 3 tech challenges/ common issues you face?
Is there any target staging area in informatica not staging area
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
define galaxy repository in informatica
Which development components of informatica have the highest usage?
What is decode in informatica?
