Informatica Intermediate Quiz

Posted on: | By: – 2 Comments

Informatica Quiz

Informatica Quiz : This Informatica Intermediate Quiz contains set of 60 Informatica Quiz which will help to clear any exam which is designed for Intermediate.



1) How many return ports are allowed in unconnected lookup transformation ?

  1. 2
  2. 1
  3. 3
  4. Any number

Answer : B

 
 
2) which reference is used to call an unconnected lookup transformation?

  1. :LKP
  2. :LPK
  3. LKP
  4. no reference is required

Answer : A

 
 
3) the transformation that control how the rows are flagged for Insert, Update, Reject or Delete in a Mapping

  1. Router
  2. Lookup
  3. Update Strategy
  4. Filter

Answer : C

 
 
4) The kinds of information that are stored in the repository are

  1. Repository configuration details
  2. Mappings
  3. Workflows
  4. All of the above

Answer : D

 
 
5) Which PowerCenter applications are used for creating and administrating folders?

  1. Administration Console and Workflow manager
  2. Repository Manager and Administration Console
  3. Workflow Manager and Workflow Monitor
  4. Designer and Workflow Manager.

Answer : B

 
 
6) The dependency window can display following type of dependency

  1. source target dependencies
  2. Mapping dependencies
  3. shortcut dependencies
  4. All of the above

Answer : D

 
 
7) Which types of objects can be visible in the Repository Manager Navigator window?

  1. Mappings, repository users, and source and target definitions
  2. Repository users, folders and sub folders ,and source and target definitions
  3. Business components,Mappings,reusable transformations
  4. Mappings and Mapplets,Integration Services,and folders and subfolders

Answer : C

 
 
8) One of the following partition types available to Informatica ensures that data is evenly distributed among all partitions

  1. Hash partitioning
  2. n:n Master/Detail partitioning
  3. Keyrange partitioning
  4. Round-robin partitioning

Answer : D

 
 
9) If you have created a session using source-based commit, which partition type do you use on the Relational and Flat File targets?

  1. Round-Robin Partitioning
  2. Pass-Through
  3. Data-Driven
  4. Hash User-Keys

Answer : B

 
 
10) A partition executes in a _________

  1. single reader, transformation, or writer thread
  2. single reader, or writer thread
  3. multiple reader, transformation, or writer thread
  4. single reader, multiple transformation, or multiple writer thread

Answer : A




 
11) Which partition type need to be used if the target tables are partitioned on key range

  1. round robin
  2. Hash auto keys
  3. Key Range
  4. database

Answer : C

 
 
12) Partitioning option helps configure which of the following?

  1. Multiple partitions for a single pipeline stage, Partitioning information that controls the number of threads (reader, transformation, and writer)
  2. Number of source and target connections to use
  3. How the Integration Service reads data from the source, distributes rows of data to each transformation
  4. All of the above

Answer : D

 
 
13) You cannot create partition point for which of the following transformations

  1. Source Qualifier
  2. Joiner
  3. Sequence Generator
  4. Both A & C

Answer : c

 
 
14) Which of the following is true in case of a Round Robin partitioning type

  1. The integration service passes all rows at one partition point to the next partition point without redistributing them
  2. The integration service passes the data to each partition depending on the ranges you specify for each port
  3. The integration service distributes data evenly among all partitions
  4. The integration service distributes data to the partitions by group

Answer : c

 
 
15) Which is not a type of partition?

  1. Round robin
  2. database
  3. pass through
  4. key hash

Answer : D

 
 
16) Which of following changes to mappings can cause partitioned session failure?

  1. Delete a transformation that was a partition point
  2. Add a transformation that is a default partition point
  3. Move a transformation that is a partition point to a different pipeline
  4. All of the above

Answer : D

 
 
17) Which of the below statements is true?

  1. You can change the parameter file when the workflow is running
  2. You cannot change the parameter file when the workflow is running
  3. once a parameter file is created, it can never be changed.
  4. parameter files can be created dynamically

Answer : B

 
 
18) What is the difference between a mapping parameter and a mapping variable?

  1. A parameter value can change throughout a Session Task run, and a mapping variable value remains constant.
  2. A parameter value remains constant throughout a Session Task run, and a mapping variable value can change.
  3. A parameter value must be read from a flat file, and a mapping variable value must be recalculated with an expression for each row.
  4. A mapping variable value must be read from a flat file, and a parameter value must be recalculated with an expression for each row.

Answer : B

 
 
19) Parameters are created in which tool?

  1. Repository manager
  2. Designer
  3. workflow monitor
  4. Admin console

Answer : B

 
 
20) What is the difference between the system variables $$$SessionStartTime and SESSSTARTTIME?

  1. $$$SessionStartTime returns the session start time as a string , and SESSSTARTTIME returns the session start time as date/time
  2. $$$SessionStartTime returns the session start time as integer , and SESSSTARTTIME returns the session start time as date/time
  3. $$$SessionStartTime returns the session start time as a string , and SESSSTARTTIME returns the session start time as integer
  4. There is no difference in practice.Either can be used to return the session start time.

Answer : A




 
21) Which among these is not a task specific predefined workflow variable?

  1. Condition
  2. EndTime
  3. ErrorCode
  4. ErrorName

Answer : d

 
 
22) Which is not true about built in functions $$$SessStartTime and SESSSTARTTIME ?

  1. $$$SessStartTime cannot be use in Mapping or mapplet filter condition.
  2. SESSSTARTTIME can be used in expressions.
  3. $$$SessStartTime can be used in sql overrides.
  4. NONE

Answer : a

 
 
23) Which options is false for built-in-variables:

  1. Built-in variables return either run-time or system information
  2. Values can be defined  for built-in variables in a workflow or session parameter file.
  3. The integration service sets the values for built in variables.
  4. Built-in variables can be used in expressions in Designer.

Answer : b

 
 
24) The Integration Service looks for the start value of a variable in the following order:
 

  1. Value in parameter file
  2. Value saved in the repository (if the variable is persistent)
  3. User-specified default value
  4. Datatype default value

 

  1. Value saved in the repository (if the variable is persistent)
  2. Value in parameter file
  3. User-specified default value
  4. Datatype default value

 

  1. Datatype default value
  2. Value saved in the repository (if the variable is persistent)
  3. Value in parameter file
  4. User-specified default value

 

  1. User-specified default value
  2. Datatype default value
  3. Value saved in the repository (if the variable is persistent)
  4. Value in parameter file

Answer : a

 
 
25) which among the following is not a variable function?

  1. SetMaXVariable
  2. SetMinVariable
  3. SetCountVariable
  4. SetAvgVariable

Answer : D

 
 
26) If  we  enter a space between the parameter name and the equals sign, the Integration Service interprets the space as

  1. part of the parameter name
  2. part of the parameter value
  3. Ignores it
  4. Throws an error

Answer : a

 
 
27) What is difference between $ and $$ parameters/variables?

  1. $ are User defined and $$ are System defined variables
  2. $ are System defined and $$ are User defined variables
  3. $ are Session Level defined and $$ are Mapping Level defined variables
  4. $ are Mapping Level defined and $$ are Session Level defined variables

Answer : b

 
 
28) To assign a null value to $PMBadFileDir , set the parameter or variable value to

  1. $PMBadFileDir=NULL
  2. $ PMBadFileDir=’\0’
  3. $PMBadFileDir=<null>
  4. None of the Above

Answer : c

 
 
29) Which of the below statement is not true about Mapplet

  1. Mapplets and mapplet ports display differently in the Mapplet Designer and the Mapping Designer
  2. If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation
  3. A mapplet can be active or passive depending on the transformations in the mapplet
  4. COBOL Sources and XML Sources can be used in mapplet

Answer : d

 
 
30) Which of the below statement about reusable component is true?

  1. We can revert back Reusable transformation to normal one
  2. We cannot revert back Reusable transformation to normal one
  3. Reusable components are only created in the mapping designer tool
  4. once a reusable component is created, we need to use only that in all the mappings

Answer : B




 
31) Which of the below object cannot be used in Mapplet.

  1. Expression Transformation
  2. Lookup Transformation
  3. Normalizer transformation
  4. Mapplet

 

  1. 1&2
  2. 2&3
  3. 3&4
  4. 4

Answer : C

 
 
33) A mapplet must contain at least one _____ with at least one connected port in the mapplet.

  1. Input Transformation
  2. Ouput Transformation
  3. Sequence Generator
  4. None

Answer : b

 
 
34) Which of the following actions when  performed on a mapplet  can cause an existing mappings to become invalid?
 

  1. Do not delete connected ports in an Input or Output transformation
  2. Do not change the data type, precision, or scale of connected ports in an Input or Output transformation
  3. Do not change a passive mapplet to an active mapplet or an active mapplet to a passive mapplet.
  4. All of the above

Answer : d

 
 
35) What is a mapplet?

  1. A mapplet used to run a batch of mappings
  2. A mapplet is a reusable object that is created using mapplet designer.
  3. A mapplet is a database object referred in a mapping
  4. None of the above

Answer : B

 
 
36) Which statement is true of Worklets but NOT of Mapplets?

  1. They are reusable by nature
  2. They encapsulate part of the functionality of a Workflow/Mapping
  3. They have their own Designer tool
  4. They can be nested

Answer : D

 
 
37) Which is not a valid option of UPDATE STRATEGY transformation

  1. DD_DELETE
  2. DD_INSERT
  3. DD_UPDATE
  4. DD_TRUNCATE

Answer : D

 
 
38) If you delete ports in the mapplet when the mapplet is used in a mapping, which of the following is True?

  1. It invalidates the mapping
  2. It does not invalidate the mapping
  3. It will invalidate the mapplet
  4. None of the above

Answer : A

 
 
39) which of the transformation cannot be created as Reusable transformation?

  1. sequence genertor
  2. Source qualifier
  3. sorter
  4. expression

Answer : B

 
 
40) _____________ definitions are not allowed in mapplet

  1. Target
  2. source
  3. trasnformation
  4. None of the Above

Answer : A




 
41) What happens if the Lookup table is larger than the Lookup Cache?

  1. the Power Center Server stores the overflow values in the cache files
  2. The workflow execution will fail
  3. The workflow will execute with error
  4. the system will hang

Answer : A

 
 
42) Which components are required to run a debug session?

  1. The Designer
  2. The Designer and the Workflow Manager
  3. The Designer and a running Informatica server
  4. The Designer, the Workflow Manager, and a running Informatica server

Answer : C

 
 
43) What type of debugger sessions can be configured?

  1. Use an existing non-reusable session
  2. Use an existing reusable session
  3. Create a debug session instance
  4. All of the above

Answer : D

 
 
44) What is a conformed dimension?

  1. Dimesion which is finalized.
  2. Dimesion which is connected to more than one fact.
  3. Dimesion which is connected to another dimention.
  4. Dimesion which is connected to single fact

Answer : B

 
 
45) Which is not a Valid SCD type 2?

  1. Flag
  2. Date Range
  3. Version
  4. and) Type

Answer : C

 
 
46) Which SCD type stored Partial history?

  1. SCD type1
  2. SCD Type 2
  3. SCD Type 3
  4. None of the Above

Answer : C

 
 
47) Which type of SCD can store the complete history

  1. SCD type1
  2. SCD Type 2
  3. SCD Type 3
  4. None of the Above

Answer : B

 
 
48) Which is not a valid options in Target Load type Property?

  1. BULK
  2. NORMAL
  3. FULL
  4. A & B

Answer : B

 
 
49) The tasks that can be performed using Workflow Manager

  1. Create sessions, view object dependencies, run workflows, edit mappings
  2. Create and delete workflows, configure connections, create tasks
  3. Create and delete workflows, create tasks, restore repositories
  4. Create and Edit tasks, Start and stop Informatica server, monitor workflows

Answer : B

 
 
50) Which one of the following statements is NOT correct?

  1. Workflows must be within Tasks to be executed
  2. Tasks must be within Workflows to be executed
  3. Workflow links may contain conditions
  4. Workflows may contain worklets.

Answer : A

 
 
51) Which of the following is a type of workflow task?

  1. Database Bulk Loading
  2. Event Raise
  3. Ranking
  4. Sorting

Answer : B




 
51) How to run a workflow without using GUI i.e, Workflow Manager, Workflow Monitor?

  1. From Oracle Database
  2. Using ‘runworkflow’ command
  3. Using pmcmd command
  4. None of the above

Answer : C

 
 
52) In a sequential batch, can we run the session if previous session fails?

  1. Yes, the second session will run even if the first session fails
  2. the second session has no dependency of the first session
  3. We cannot run sessions sequentially in workflow manager
  4. the second session will by default fail if the first session fails

Answer : A

 
 
53) If a session fails after loading of 10000 records into the target. How can you load the records from 10001th record when you run the session next time?

  1. Restart the session normally
  2. Restart the session using session recovery option
  3. Restart the session using workflow manager option
  4. It is not possible to load from 10001th record

Answer : B

 
 
54) Difference between stop and abort

  1. Stop – Stops the Session
  2. Abort – Kills the session.
  3. Stop – Kills the session.
  4. Abort – Stops the session
  5. Both stops the session
  6. None of the above

Answer : A

 
 
55) Which command line program should you use to start a workflow from a batch file?

  1. infacmd
  2. infasetup
  3. pmrep
  4. pmcmd

Answer : D

 
 
56) Which of the following objects can be scheduled?

  1. Workflows
  2. Sessions
  3. Worklets
  4. Command Tasks

Answer : A

 
 
57) which command is used to execute workflow tasks from the command line

  1. PMREP
  2. PMCMD
  3. REPCMD
  4. CMD

Answer : B

 
 
58) A scheduling tool from BMC software

  1. and) CONTROL M
  2. Autosys
  3. workflow scheduler
  4. Maestro

Answer : A

 
 
59) How to determine whether the incoming record already exists in the target table?

  1. Using Router Transformation
  2. Using Lookup Transformation
  3. Using Aggregate Transformation
  4. Writing a select query on toad

Answer : B

 
 
60) A pipeline consists of a ______

  1. source qualifier ,all the transformations and targets that receive data from that source qualifier
  2. source qualifier and all the transformations from that source qualifier but not target
  3. source qualifier ,all the transformations and all the targets in the mapping from other sources as well
  4. none of the above

Answer : A




 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz

2 Replies to “Informatica Intermediate Quiz”

Comments are closed.