Sunday 1 February 2015

Informatica Part6 Interview Questions and Answers (Part6)

51.     SCD MAPPINGS ARE MOSTLY USED UNCONNECTED LOOKUP TRANSFORMATION. UNCONNECTED LOOKUP USED STATIC CACHE ONLY. AT THIS TIME HOW CAN YOU INSERT OR UPDATE DATE IN TARGET BY USING STATIC CACHE?
There is no connected lookup t/r n by default it takes static cache.For insert n update operations we use dynamic cache.

52.     WHAT ARE THE JOINER CACHES?
When a Joiner transformation occurs in a session, the Informatica Server reads all the records from the master source and builds index and data caches based on the master rows. After building the ca

53.     WHY DID U USE UPDATE STATEGY IN YOUR APPLICATION?
Update Strategy is used to drive the data to be Inert, Update and Delete depending upon some condition. You can do this on session level tooo but there you cannot define any condition.For eg: If you w

54.     WHAT IS DIFFERENCE BETWEEN PARTIONING OF RELATONAL TARGET AND PARTITIONING OF FILE TARGETS?
Partition's can be done on both relational and flat files. Informatica supports following partitions 1.Database partitioning 2.RoundRobin 3.Pass-through 4.Hash-Key partitioning 5.Key

55.     WHAT ARE THE NEW FEATURES OF THE SERVER MANAGER IN THE INFORMATICA 5.0?
You can use command line arguments for a session or batch.This allows you to change the values of session parameters,and mapping parameters and maping variables. Parallel data processing: This feature

56.     WHAT IS THE DIFFERENCE BETWEEN SUMMARY FILTER AND DETAIL FILTER?
Summary filter can be applieid on a group of rows that contain a common value.where as detail filters can be applied on each and every rec of the data base.

57.     WHAT ARE THE CONNECTED OR UNCONNECTED TRANSFORMATIONS?
An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.

58.     HOW TO IMPORT ORACLE SEQUENCE INTO INFORMATICA.
CREATE ONE PROCEDURE AND DECLARE THE SEQUENCE INSIDE THE PROCEDURE,FINALLY CALL THE PROCEDURE IN INFORMATICA WITH THE HELP OF STORED PROCEDURE TRANSFORMATION.

59.     WHAT ARE THE REAL TIMES PROBLEMS GENERALLY COME UP WHILE DOING/RUNNING MAPPING/ANY TRANSFORMATION? CAN ANYBODY EXPLAIN WITH EXAMPLE.
Here are few real time examples of problems while running informatica mappings: 1) Informatica uses OBDC connections to connect to the databases. The database passwords (production ) is changed in

60.     IF A SESSION FAILS AFTER LOADING OF 10,000 RECORDS IN TO THE TARGET. HOW CAN U LOAD THE RECORDS FROM 10001 THE RECORD WHEN U RUN THE SESSION NEXT TIME?
As explained above informatcia server has 3 methods to recovering the sessions.Use performing recovery to load the records from where the session fails.
More Questions & Answers :-

No comments:

Post a Comment