Informatica Beginner Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
2) .……………….. is the primary unit for management and administration within PowerCenter

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
3) A ……….. is the logical representation of a machine in a domain

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
4) ………… allow users to create shortcuts to objects in the folder

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
6) Which among the following is not an Application service

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
7) Which service is responsible for executing the mappings

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
10) …………… is a repository object that generates, modifies, or passes data

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
13) Relational source definitions can be imported from :

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
19) Mappings represent :

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
23) Which of the following cannot be used as Targets

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
24) A flat file cannot be used as the following

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
26) Shortcuts can be created from which of the following?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
27) Which of the following is not a Active Transformation ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
28) Which of the following Transformations does not use cache files ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
30) Which of the following transformations does not have variable port ?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
32) ………….. contains a set of transformations that can be reused in multiple mappings

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
38) ……………….. is an example of Passive Transformation

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
48) Which among the following is not a type of workflow task

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
49) A session task is a type of :

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
53) Which of the following is a type of workflow task?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
57) You can also create an _________ file for workflow log events

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
58) What is Default Recovery Strategy for Session

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : c[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : a[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
61) which command is used to execute workflow tasks from the command line

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
62) A scheduling tool from BMC software

  1. CONTROL M
  2. Autosys

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
63) -sv’ option of PMCMD command is used to specify______________ name

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz