Informatica MCQs Set: 1

Informatica MCQs Set: 1

Informatica free practice questions lets you to boost your confidence on nuances of informatica techonology.A great place for you to enhance your knowledge.

Most Frequently asked Informatica Interview Questions and Answers: This article is covering the top Informatica MDM, PowerCenter, Workflow Manager, Workflow Monitor, Designer etc.

Q1) HOW MANY TYPES OF DATA EXTRACTION ARE THERE

       1, 2, 3, 4 OR 5 

   

ANS 2

REASON:

            There are two kinds of logical extraction:

·         Full Extraction

The data is extracted completely from the source system.

·         Incremental Extraction

At a specific point in time, only the data that has changed since a well-defined event back in history will be extracted.

Q2) What is the data format u prefer for informatica server

        1) ASCII 2)EBCDIC 3)UNICODE 4)DECIMAL 5) BINARY

REASON:

            Possible values are ASCII and UNICODE. The default data movement mode is ASCII, which passes 7-bit ASCII character data. To pass 8-bit ASCII and multi byte character data from sources to targets, use the Unicode mode.

Q3) IF max no of sessions are 20 then what is the minimum shared memory size

    1)2000000 2)1000000 3)4000000 4)3000000

REASON:

            For every 10 sessions in Max Sessions, you need at least 2,000,000 bytes reserved in LMSharedMem. The default is 2,000,000 bytes.

Q4) What are the dependencies of repository manager (check box question?)

  1) workflow dependencies2) worklet dependencies 3) mapping dependencies 4) source dependencies 5) transformation dependencies

REASON & ANSWER:

             The repository manager displays following dependencies:

1)    Source-Target  2) Mapping 3) Short cut dependencies

Q5) Config tab contains -------- and ------- properties (check box one)

1) Commit

2) Reject

3) Commit on insert

4) Commit on update

5) Load

Q6) What are the things that should be configured when a source is directly imported from database?

1) Data base name

2) Owner name

3) Index name

4) Constraint name

5) Data base type

NOTE:

            This is just my opinion of the answer. The two sets of ans tat was actually marked were:

1,2,3 and 3,4,5.

Q7) An informatica variable contains

1)startvalue/end value

2)start value/current value

3)start value//persistent value

4)start value/…..

5)start value/dynamic value

REASON:

            Mapping variable represents a value that can be changed during the mapping run. Mapping variables have two identities:

Start value and Current value

Q8)some question like………….. what are the groups in router transformation

  1)user defined groups

   2)constant groups

Some other options

We guess the ans is user defined.

NOTE:

      A Router transformation has the following types of groups:

§  Input

§  Output

Input Group

       The Designer copies property information from the input ports of the input group to    create a set of output ports for each output group.

Output Groups

         There are two types of output groups:

• User defined
• Default

Q9)set of source and target definitons and tranformations is called

Ans Mapping

Q10) Some question  like ENTERED_DATE and APPLIED_DATE

Ans . IIF((ENTERED DATE>APPLIED DATE) DD_REJECT,DD_UPDATE)