in Technology by
What are the types of Caches in lookup? Explain them.

1 Answer

0 votes
by

Based on the configurations done at lookup transformation/Session Property level, we can have following types of Lookup Caches.

  • Un- cached lookup– Here, the lookup transformation does not create the cache. For each record, it goes to the lookup Source, performs the lookup and returns value. So for 10K rows, it will go the Lookup source 10K times to get the related values.
  • Cached Lookup– In order to reduce the to and fro communication with the Lookup Source and Informatica Server, we can configure the lookup transformation to create the cache. In this way, the entire data from the Lookup Source is cached and all lookups are performed against the Caches.

Based on the types of the Caches configured, we can have two types of caches, Static and Dynamic.

The Integration Service performs differently based on the type of lookup cache that is configured. The following table compares Lookup transformations with an uncached lookup, a static cache, and a dynamic cache:
Lookup-transformations-informatica-interview-questions

Persistent Cache

By default, the Lookup caches are deleted post successful completion of the respective sessions but, we can configure to preserve the caches, to reuse it next time.

Shared Cache

We can share the lookup cache between multiple transformations. We can share an unnamed cache between transformations in the same mapping. We can share a named cache between transformations in the same or different mappings.

Related questions

0 votes
    What are the different types of caches available in Hibernate?...
asked Feb 4, 2021 in Technology by JackTerrance
0 votes
    What is meant by Lookup Transformation? Explain the types of Lookup transformation....
asked Mar 27, 2021 in Technology by JackTerrance
0 votes
    Explain The Differences Between "direct Mapped", "fully Associative", And "set Associative" Caches ?...
asked Dec 12, 2020 in Technology by JackTerrance
0 votes
    What command is used for remove all stopped containers, unused networks, build caches, and dangling images? docker system kill ... kill -a docker system prune docker system rm -a...
asked Jun 22, 2021 in Technology by JackTerrance
0 votes
    What are the types of Schemas we have in data warehouse and what are the difference between them?...
asked Mar 29, 2021 in Technology by JackTerrance
0 votes
    What are the different types of object relations in salesforce? How can you create them?...
asked Nov 11, 2020 in Technology by JackTerrance
0 votes
    what are three types of network and define them with example Select the correct answer from above options...
asked Dec 17, 2021 in Education by JackTerrance
0 votes
    What are the differences between connected lookup and unconnected lookup?...
asked Mar 25, 2021 in Technology by JackTerrance
0 votes
    How to insert different types of slides and images into the slides and apply animation and transition on them Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
    i need the types of computers and the main characteristics of each of them Select the correct answer from above options...
asked Dec 19, 2021 in Education by JackTerrance
0 votes
    What is Lookup change in Informatica?...
asked Jun 7, 2021 in Technology by JackTerrance
0 votes
    What do you understand by the record matching and data lookup features in ServiceNow?...
asked May 24, 2021 in Technology by JackTerrance
0 votes
    Write the Unconnected lookup syntax and how to return more than one column....
asked Mar 29, 2021 in Technology by JackTerrance
0 votes
    Differentiate between joiner and Lookup Transformation....
asked Mar 27, 2021 in Technology by JackTerrance
...