Informatica Interview Question and Answers

57. What are the types of lookup caches?
  • Persistent cache: You can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache.
  • Recache from database: If the persistent cache is not synchronized with he lookup table, you can configure the lookup transformation to rebuild the lookup cache.
  • Static cache: You can configure a static or readonly cache for only lookup table. By default informatica server creates a static cache.It caches the lookup table and lookup values in the cache for each row that comes into the transformation.when the lookup condition is true,the informatica server does not update the cache while it prosesses the lookup transformation.
  • Dynamic cache: If you want to cache the target table and insert new rows into cache and the target,u can create a look up transformation to use dynamic cache. The informatica server dynamically inerts data to the target table.
  • Shared cache: you can share the lookup cache between multiple transactions. You can share unnamed cache between transformations inthe same maping.
Your Name Your Email-ID
Your Answer
58. What are the options in the target session of update strategy transsformatioin?
  • Insert
  • Delete
  • Update
  • Update as update
  • Update as insert
  • Update esle insert
  • Truncate table
Your Name Your Email-ID
Your Answer
59. What are two types of processes that informatica runs the session?
  Load manager Process:
  • Starts the session, creates the DTM process, and sends post-session email when the session completes.
    The DTM process:
  • Creates threads to initialize the session, read, write, and transform data, and handle pre- and post-session operations.
Your Name Your Email-ID
Your Answer
60. Does the designer allow you to work on multiple tools and multiple folders at a time?
Your Name Your Email-ID
Your Answer

131415 Page 15 of 15