When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
Answer Posted / rayudu
When we want to return multiple ports from a mapping we wil
use connected lookup.
An connected lookup returns only one port from the t/r. If
we want to use lookup multiple times in a mapping and if we
want to lookup data only when the condition is true we will
use unconnected lookup. (if we dont want to look up all the
records and only some records)
regards,
rayudu
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is a surrogate key?
how we can load rejected record's at run time?(not through bad files)
How identifying bottlenecks in various components of informatica and resolving them?
Differentiate between joiner and lookup transformation?
In informatics server which files are created during the session rums?
Where is metadata stored?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
what is index?how it can work in informatica
How are the sources and targets definitions imported in informatica designer?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to create a non-reusable instance of reusable transformations?
What is the format of informatica objects in a repository?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
To import the flat file definition into the designer where should the flat file be placed?