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

Show Answer

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

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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.

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
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

Show Answer

 
 
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

Show Answer

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

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

Show Answer

 
 
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

Show Answer

 
 
15) Which is not a type of partition?

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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.

Show Answer

 
 
19) Parameters are created in which tool?

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

Show Answer

 
 
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.

Show Answer

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

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

Show Answer

 
 
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

Show Answer

 
 
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.

Show Answer

 
 
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

Show Answer

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

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

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

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

Show Answer

 
 
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

Show Answer

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

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

Show Answer

 
 
40) _____________ definitions are not allowed in mapplet

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

Show Answer

 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
45) Which is not a Valid SCD type 2?

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

Show Answer

 
 
46) Which SCD type stored Partial history?

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

Show Answer

 
 
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

Show Answer

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

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

Show Answer

 
 
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

Show Answer

 
 
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.

Show Answer

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

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

Show Answer

 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer

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

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

Show Answer

 
 
56) Which of the following objects can be scheduled?

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

Show Answer

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

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

Show Answer

 
 
58) A scheduling tool from BMC software

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

Show Answer

 
 
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

Show Answer

 
 
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

Show Answer