Informatica MCQs Set: 13

Informatica MCQs Set: 13

1. Number of log files by default in Infa?
1. 1
2. 2
3. 3 (session log, workflow log, reject log)
4. 4
5. 5
2. Which window helps to access the Repositories ?
1. Navigation Window
2. Property Window
3. Workflow Monitor
4. Workflow Manager

1. The primary server process in the infa Server?
1. Repository Manager
2. Load manager
3. Workflow manager
4. Workflow Designer
2. Which transformation helps to convert the rows into columns?
1. Rank Transformation
2. Sorter Transformation
3. Normalizer Transformation
4. Update Strategy
3. Which transformation row updates distinct records into target table?
1. Update Strategy
2. Rank
3. Sorter
4. Aggregation

    No. of components in the Workflow Manager

5. 1
6. 2
7. 3
8. 4
9. 5
5. Writing scripts to schedule Workflows … what mode is this
1. Interactive mode
2. Command line mode
6. User, Groups, Privileges are created in which client tool?
1. Repository manager
2. Workflow Manager
3. Workflow monitor
4. Designer
7. What types of data sources are there in Infa? (all the options are correct but we had to select only one option)
1. Flat files
2. Homogenous and heterogeneous sources
3. Flat files, Homogenous and heterogeneous sources
4. XML and Cobol sources
5. None of the above

7)In pmcmd mode for each line you need to communicate with ------------

a.informatica server

b.repository manager

c.workflow manager

d.workflow monitor

14) minimum number of transformations required to validate a mapping?

a.2

b.3

c.4

d.5

1.       Number of tools in informatica designer. Ans 5

2.      Number of ports in expression transformation. Ans 3

3.      What are the servers in informatica?

a)     Informatica server

b)     Informatica repository server

c)      Informatica server and informatica repository server

d)     None of the above

I guess answer is (a) option

       5. To operate in which pmcmd  mode, username, password and server connection details are necessary?

a)    Commandline

b)     Interactive

c)      Both

d)     None

        6. To determine which column caused the row to be rejected, what does the   server add to give more info about columns?

a)     Key indicators

b)     Key breaks

c)    Row indicator and column indicators

d)     Variable indicator

       7. What transformation should be used to get the values related to deptno 10 only in the target table?

a)     Filter

b)     Router

c)      Filter and router

d)     Source qualifier and filter

e)     Source qualifier, filter and router

              Guess ans is (a)

      8. Where do you create folders and give connection details?

a)    Repository manager

b)     Workflow manager

c)      Designer

9. when you create a workflow which task gets created by default?

a)     Start

b)     Command

c)      Assignment

d)     Timer

I marked (a). Not sure

  10. latest version of Power center can handle

a)     124 bit

b)    64 bit

c)      32 bit

d)     128 bit

2)Before you connect to the informatica server you must register it with?

a) Repository mamager

5) using pmcmd you connect to?

a)Workflow manager

6)pmcmd is used to connect with?

a)Powercentre or informatica server or powermart whichever you find as the answer there

7) In where can you prepare a reusable transformation

a)transformation designer

8)Where in Informatica will the business logics be applied

a)Transformation Developer

9)What will you use to to join an RDBMS input file and an XML file

a)Source Qualifier and Union( I am not very sure of this)

10)When you use update trategy trasnformation which is the default mode?

a)Insert

11)Where is that you design tasks so that it runs sequentially or in some order defined?

a)Workflow designer

3. While running workflow informatica server gets connection with

a. Repository server.

b. Workflow Manager.

c. Workflow Monitor.

d. Repository Manager

6. Email to customers.

a. Email individual

b. Put in public folder

c. bursting

How many modes in pmcmd

a) 1

b) 2

c) 3

d) 4

what do mean by nesting

a) one dimension above to another

b) one dimension below  to another

c) one dimension next to another

which transformation is used to reject load files

a) source qualifier transformation

b) router transformation

c) either source qualifier nor router

b) source quailifier,router and filter transformation

How many transformation are there ?

 a)12

 b)16

 c)8

 b)13

what do u mean parent fails current task fails

a) current task fail if parent fail

b) parent fail if the current task fail

c) current task only fail

d) both current and parent fail

which should be used to define a interval between two task

a) set wait

b) set no wait

c) wait

Look up transformation syntax

1. A developer wishes to use the data previewwe to determine the total number of rows in a relational source table. The number of rows exceeds 10000.what is the proper  procedure for this operation?

1. Connect the data Previewer to the source table with all settings left to the defaults.
2. Connect the data Previewer to the source table and check the option “Count rows”
3. This operation is not supported because the number of rows exceeds 10000. It is supported only when number of rows is 10000 or less.
4. This operation is not supported.

2. How many repositories can you simultaneously work in a single Designer environment?

2 repositories

4.  Under what circumstances can a Target definition be edited from the Mapping         Designer ,within the mapping where that Target definition is being used ?

a.When the Target definition is not shared(not a shortcut)

b.When the Target definition is not shared(not a shortcut) and when the user has write permission on the folder where the mapping is stored

c.Always

d.Never

5  .A User desires to join two relational sources with a single Source Qualifier have been correctly imported into the mapping . Next, she must establish a primary/foreign key relationship between two ports in the source definitions. Assuming that the relationship does not currently exist on the database server,what are the required steps to do this?

a. Use the source Analyser to establish that primary/foreign key relationship and save the repository

b. Use the source Analyser to establish that  primary/foreign key relationship,save the repository,and run the appropriate SQL statement on the database tables t ocreate the actual primary / foreign key relationship

c.Use the source Analyser to establish that  primary/foreign key relationship,open the SQL Editor in the Source qualifierand generate the join statement,modify the join statement is required and save the repository.

d. Use the source analyzer to establish that primary /foreign key relationship , regenerate the source Qualifier SQL using the SQL editor,press the okay button and save the repository.

1. What types of data sources are there in Infa? (all the options are correct but we had to select only one option)

a.       Flat files

b.      Homogenous and heterogeneous sources

c.       Flat files, Homogenous and heterogeneous sources

d.      XML and Cobol sources

e.       None of the above

7.      In informatica, you can create a shortcut to the folder by checking the checkbox:

§  Allow shortcut

§  Create shortcut

§  Shortcut

§  Folder shortcut

8.      Worklet contains a set of

§  Mappings

§  Tasks

§  Sessions

§  Mapplets

9.      Which task is used to send an email after the workflow is completed

§  Event

§  Command

§  Email

§  timer

10.  Using which transformation can you update distinct records into the target table.

§  Filter

§  Router

§  Update strategy

§  Sequence generator

11.  Which command is used to call a transformation from lookup to expression

§  LKP:Lookup….

§  Some options like this

26. The primary server process in the infa Server?
1. Repository Manager
2. Load manager
3. Workflow manager
4. Workflow Designe
27. Writing scripts to schedule Workflows … what mode is this
1. Interactive mode
2. Command line mode

1.use of surrogate keys

 Ans:improve performance

2.in which SCD we use different surrogate keys

Ans: none

3: no of permissions in folder(infa)

Ans: 7

4: timeout in repository manager(infa)

 Ans: 60 secs