Informatica MCQs Set: 5

Q1)if the data does not change from session to session the cache use is

Ans.. persistant cache 

12 which one of these non-reusable transformation………….

A} ERP

B} Seq Generator Transform

C} Look up Transform

D} Dynamic lookup cache

REASON:

The transformations that cannot be used in MAPPLET and REUSABLE TRANSFORMATION are:

TARGET, NORMALISER, COBOL SOURCE, XML SOURCES, UPDATE STRATEGY, XML SOURCE, QUALIFIER, TARGET DEFINITION

13 Types of Lookup cache…….

A} Dynamic Cache

B} Volatile Cache

C} Non volatile Cache

D} Re Cache from DB

E} Static Cache

REASON:

Persistent cache: U can save the lookup cache files and reuse them the next time the informatica server processes a lookup transformation configured to use the cache.

Re cache from database: If the persistent cache is not synchronized with he lookup table,U can configure the lookup transformation to rebuild the lookup cache.

Static cache: U 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 u 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: U can share the lookup cache between multiple transactions.U can share unnamed cache between transformations inthe same maping. 

14 How will you improve performance of lookup transform?

A} Use memory cache for Large DB

B} Don’t Use cache for Small tables

C}use big cache…

15 Where aggregate store data in the processing………

Ans  Cache

16 By default aggregate treats

Ans NULL as NULL (All numeric, character are treated as NULL)

17 Performance of Aggregate, Look up transform improved by sorter and cache

18.Diff Between Informatica 5.1 and 6.1 Version……….

A}Trans Control

B}Sorting

20 Number of transformation threads ……….. in Informatica into each  pipeline.

Ans: Partitioning