When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
Answer Posted / rascal
connected lookup is used when we need to use dynamic cache,we can return multiple o/p&need to use default values...otherwise if we want to use same lookup multiple times in the mapping then we go for un-connected lookup..In this case we can use only static cache..
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you load alternate records into different tables through mapping flow?
How to join three sources using joiner?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What differs when we choose the sorted input for aggregator transformation?
What is a mapplet/worklet in informatica?
How are the sources and targets definitions imported in informatica designer?
Can we create multiple integration service on single repository?
How many ways are there to create ports?
What is an unconnected transformation?
How is union transformation utilized?
Is stop and abort are same in informatica?
What is rank index in rank transformation?
What is the function of union transformation?
How does the aggregator transformation handle null values?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.