Informatica Beginner Quiz

Informatica Quiz

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



1) You define a set of instructions to execute tasks, using :

  1. Workflow Monitor
  2. Workflow Manager
  3. Repository Manager
  4. PowerCenter Designer

Answer : B

 
 
2) .……………….. is the primary unit for management and administration within PowerCenter

  1. Repository Manager
  2. Workflow Manager
  3. Administration Console
  4. Power Center Domain

Answer : D

 
 
3) A ……….. is the logical representation of a machine in a domain

  1. Node
  2. Server
  3. Grid
  4. Service

Answer : A

 
 
4) ………… allow users to create shortcuts to objects in the folder

  1. Integration Service
  2. Ans)Shared Folder
  3. Repository Security
  4. Administration Console

Answer : B

 
 
5) The Integration Service connects to the repository through the …………… to fetch metadata from the repository

  1. Repository Service
  2. Repository Manager
  3. Reporting Service
  4. Metadata Manager Service

Answer : A

 
 
6) Which among the following is not an Application service

  1. Integration service
  2. Repository service
  3. Log service
  4. reporting service

Answer : C

 
 
7) Which service is responsible for executing the mappings

  1. Integration service
  2. Repository service
  3. Log service
  4. reporting service

Answer : A

 
 
8) Which are the types of services which need not to be created by the Administrator?

  1. SAP BW service
  2. Core
  3. Repository service
  4. Application service

Answer : B

 
 
9) A  set of source and target definitions linked by transformation objects that define the rules for data transformation is called a

  1. Mapping
  2. Worklet
  3. Workflow
  4. Schema

Answer : A

 
 
10) …………… is a repository object that generates, modifies, or passes data

  1. Transformation
  2. DTM
  3. Mapping
  4. Integration Service Process

Answer : A




 
11) To create or import source definitions, ………….. is used in the Designer

  1. Target Designer
  2. Transformation Developer
  3. Mapping Designer
  4. Source Analyzer

Answer : D

 
 
12) To extract data from a source, first step in the Designer is  :

  1. create a session
  2. data profiling
  3. define sources in the repository
  4. create a workflow

Answer : C

 
 
13) Relational source definitions can be imported from :

  1. tables
  2. tables, views, synonyms
  3. tables, views
  4. tables, views, stored procedures

Answer : D

 
 
14) When a relational source definition is imported, which of the following source metadata is imported ?

  1. triggers
  2. stored procedures
  3. Column Names, Datatypes
  4. Column Names, Datatypes, Key constraints

Answer : D

 
 
15) What type of files can be imported for flat-file source/target definitions in the repository ?

  1. Fixed-width
  2. Delimited
  3. Fixed-width and delimited flat files that do not contain binary data
  4. Binary

Answer : C

 
 
16) Target Designer is used to :

  1. Import or create target definitions
  2. Create mappings
  3. Import or create source definitions
  4. Create target definitions

Answer : A

 
 
17) In which of the following ways can the target definitions be created ?

  1. Create a target definition based on a source definition
  2. Manually create a target definition
  3. Import the target definition from a relational target or a flat file
  4. All of the above

Answer : D

 
 
18) Which types of target definitions can be created in the Target Designer ?

  1. Relational
  2. Relational, Flat file, XML file
  3. Binary file
  4. DLL file

Answer : B

 
 
19) Mappings represent :

  1. the data flow between sources and targets
  2. data extraction
  3. data cleansing
  4. data loading

Answer : A

 
 
20) When the Integration Service runs a ……………, it uses the instructions configured in the mapping to read, transform, and write data

  1. command
  2. session
  3. transformation
  4. query

Answer : B




 
21) Every mapping must contain which of the following components :

  1. Source definition
  2. Target definition
  3. Source definition, Target definition, Transformation, Links
  4. Source and Target definition

Answer : C

 
 
22) Which of the following changes cause the session to be invalid ?

  1. Adding a table in the source database
  2. Deleting rows from a target table
  3. Creating an index in the source database
  4. Adding or removing a Joiner or Update Strategy transformation in the mapping

Answer : D

 
 
23) Which of the following cannot be used as Targets

  1. XML Files
  2. Cobol Files
  3. Text Files
  4. Relational Tables

Answer : B

 
 
24) A flat file cannot be used as the following

  1. Source
  2. Target
  3. Aggregator
  4. Lookup

Answer : C

 
 
25) Which of the following objects cannot be included in a mapplet?

  1. Target Definition
  2. Source Definitions
  3. Router Transformation
  4. Update Strategy Transformation

Answer : A

 
 
26) Shortcuts can be created from which of the following?

  1. Source Definitions
  2. Reusable transformations
  3. Mapplets
  4. All the above

Answer : D

 
 
27) Which of the following is not a Active Transformation ?

  1. Filter
  2. Sequence Generator
  3. Router
  4. Update Strategy

Answer : B

 
 
28) Which of the following Transformations does not use cache files ?

  1. Sorter
  2. Router
  3. Rank
  4. Aggregator

Answer : B

 
 
29) Which of the following is not a lookup cache property ?

  1. Dynamic Lookup Cache
  2. Static Lookup Cache
  3. Persistent Lookup Cache
  4. Active Lookup Cache

Answer : D

 
 
30) Which of the following transformations does not have variable port ?

  1. Expression
  2. Rank
  3. Filter
  4. Aggregator

Answer : C




 
31) The output from an Aggregator transformation without a Group by will return?

  1. All records
  2. Error
  3. 1 record
  4. None of the above

Answer : C

 
 
32) ………….. contains a set of transformations that can be reused in multiple mappings

  1. Worklet
  2. Mapplet
  3. Custom Transformation
  4. Workflow

Answer : B

 
 
33) An Active Transformation :

  1. Does not change the number of rows that pass through it
  2. Represents the data flow between sources and targets
  3. Can change the number of rows that pass through it
  4. Creates a target definition based on a source definition

Answer : C

 
 
34) When you add a relational or a flat file source definition to a mapping, you need to connect it to a

  1. Joiner Transformation
  2. Aggregator Transformation
  3. Source Qualifier Transformation
  4. Expression Transformation

Answer : C

 
 
35) In Joiner Transformation, if Master Outer Join type is used, it will :

  1. Keep all rows of data from the detail source and the matching rows from the master source, and discards the unmatched rows from the master source
  2. Discard all rows of data from the master and detail source that do not match, based on the condition
  3. Keep all rows of data from the master source and the matching rows from the detail source, and discards the unmatched rows from the detail source
  4. Keep all rows of data from both the master and detail sources

Answer : A

 
 
36) To test data for one or more conditions and route rows of data that do not meet any of the conditions to a default output group, which transformation would you use ?

  1. Sorter Transformation
  2. Router Transformation
  3. Joiner Transformation
  4. Filter Transformation

Answer : B

 
 
37) A transformation that does not change the number of rows that pass through it, is called :

  1. Passive Transformation
  2. Connected Transformation
  3. Mapplet
  4. Source Qualifier

Answer : A

 
 
38) ……………….. is an example of Passive Transformation

  1. Update Strategy Transformation
  2. Router Transformation
  3. Expression Transformation
  4. Rank Transformation

Answer : C

 
 
39) ……………….. is used to control on a row by row basis, whether the row is to be inserted, updated, deleted or a rejected based on some logical condition

  1. Sorter Transformation
  2. Update Strategy Transformation
  3. Joiner Transformation
  4. Normalizer Transformation

Answer : B

 
 
40) To concatenate first name and last name of an employee, which transformation would be used ?

  1. Aggregator Transformation
  2. Joiner Transformation
  3. Expression Transformation
  4. Normalizer Transformation

Answer : C




 
41) Aggregator Transformation performs :

  1. calculation of values in a single row
  2. concatenation of columns/ports in a row
  3. aggregate calculations, such as averages and sums
  4. calculations on a row-by-row basis

Answer : C

 
 
42) Which of the following is not True with respect to Sorter transformation ?

  1. Sorter uses cache memory to sort data
  2. Sorter is a Passive Transformation
  3. Sorter can be used to remove duplicate records
  4. All the above

Answer : B

 
 
43) What types of transformation ports are valid ones?

  1. Input, Output, Variable
  2. ans)Input, Output, Input/Output, Variable
  3. Input, Output, Variable, Aggregate
  4. Input, Output, Input/Output, Variable, Parameter

Answer : B

 
 
44) What value would the function GET_DATE_PART (DATE_SHIPPED, ‘HH’) return
when the value of DATE_SHIPPED is null?

  1. 0
  2. Null
  3. 12
  4. A Transformation error is generated

Answer : B

 
 
45) For triming leading & trailing spaces of a in Informatica the following function is used

  1. TRIM(VALUE)
  2. LTRIM(VALUE)
  3. LTRIM(RTRIM(VALUE))
  4. All of the above

Answer : C

 
 
46) A set of instructions to execute tasks such as sessions, emails, shell commands etc is called :

  1. Mapping
  2. Load Balancer
  3. Workflow
  4. Transformation

Answer : C

 
 
47) A session :

  1. is a set of instructions that describes how and when to execute tasks related to extraction, transformation and loading data
  2. is an object that groups a set of tasks
  3. is a set of instructions that describes how to move data from source to target using a mapping
  4. Reads workflow information from the repository

Answer : C

 
 
48) Which among the following is not a type of workflow task

  1. Event wait
  2. Event raise
  3. Timer
  4. Filter

Answer : D

 
 
49) A session task is a type of :

  1. transformation
  2. worklet
  3. workflow task
  4. mapplet

Answer : C

 
 
50) Chrological details of workflow tasks can be viewed in

  1. Gantt chart view
  2. task view
  3. Workflow view
  4. we cant view chronological details in worklow monitor

Answer : A




 
51) In a Workflow , you need to run an operating system script between two sessions. How can you best accomplish this?

  1. Call from Post SQL
  2. Call the script from a Command task
  3. Use a custom transformation
  4. Use Event raise and Event wait tasks

Answer : B

 
 
52) Are user-defined events supported in PowerCenter workflows?

  1. No, because only File Wait events are supported in the Event-Wait task.
  2. Yes, but only in workflows containing worklets.
  3. No, because Event-raise tasks do not support user-defined events.
  4. Yes, using a combination of Event-Raise and Event-Wait tasks

Answer : D

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

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

Answer : B

 
 
54) A workflow fails and you need to consult the logs. Which PowerCener application will allow you consult the session and workflow logs?

  1. Designer
  2. Administration console.
  3. Workflow Monitor
  4. Workflow Manager.

Answer : C

 
 
55) A Workflow log does not contain which of the following?

  1. Status of tasks and worklets in the workflow
  2. Errors encountered during the workflow and general information
  3. Status of tasks and worklets in the workflow
  4. None of the above

Answer : D

 
 
56) To determine the cause of workflow or session problems & resolve it?

  1. Use log events
  2. Locate the relevant log codes
  3. Locate text prefixes
  4. All of the above

Answer : D

 
 
57) You can also create an _________ file for workflow log events

  1. XML
  2. text
  3. binary log
  4. All of the above

Answer : D

 
 
58) What is Default Recovery Strategy for Session

  1. Restart task
  2. Resume from last checkpoint
  3. Fail task and continue workflow
  4. None

Answer : c

 
 
59) At which tracing level does  the Integration Service not write error messages or row-level information for reject data.

  1. Terse
  2. Verbose
  3. Both A and B
  4. Normal

Answer : a

 
 
60) You can view properties for which of the following items in the Workflow Monitor?

  1. Session, Tasks, Workflows
  2. Session, Tasks, Workflows, Links, Folders
  3. Session, Tasks, Workflows, Links, Folders, Integration Service
  4. Session, Tasks, Workflows, Links, Folders, Integration Service, Grids

Answer : D

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

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

Answer : B

 
 
62) A scheduling tool from BMC software

  1. CONTROL M
  2. Autosys

Answer : A

 
 
63) -sv’ option of PMCMD command is used to specify______________ name

  1. repository service
  2. domain name
  3. integration service name
  4. node name

Answer : C