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 :
- Workflow Monitor
- Workflow Manager
- Repository Manager
- PowerCenter Designer
2) .……………….. is the primary unit for management and administration within PowerCenter
- Repository Manager
- Workflow Manager
- Administration Console
- Power Center Domain
3) A ……….. is the logical representation of a machine in a domain
- Node
- Server
- Grid
- Service
4) ………… allow users to create shortcuts to objects in the folder
- Integration Service
- Ans)Shared Folder
- Repository Security
- Administration Console
5) The Integration Service connects to the repository through the …………… to fetch metadata from the repository
- Repository Service
- Repository Manager
- Reporting Service
- Metadata Manager Service
6) Which among the following is not an Application service
- Integration service
- Repository service
- Log service
- reporting service
7) Which service is responsible for executing the mappings
- Integration service
- Repository service
- Log service
- reporting service
8) Which are the types of services which need not to be created by the Administrator?
- SAP BW service
- Core
- Repository service
- Application service
9) A set of source and target definitions linked by transformation objects that define the rules for data transformation is called a
- Mapping
- Worklet
- Workflow
- Schema
10) …………… is a repository object that generates, modifies, or passes data
- Transformation
- DTM
- Mapping
- Integration Service Process
11) To create or import source definitions, ………….. is used in the Designer
- Target Designer
- Transformation Developer
- Mapping Designer
- Source Analyzer
12) To extract data from a source, first step in the Designer is :
- create a session
- data profiling
- define sources in the repository
- create a workflow
13) Relational source definitions can be imported from :
- tables
- tables, views, synonyms
- tables, views
- tables, views, stored procedures
14) When a relational source definition is imported, which of the following source metadata is imported ?
- triggers
- stored procedures
- Column Names, Datatypes
- Column Names, Datatypes, Key constraints
15) What type of files can be imported for flat-file source/target definitions in the repository ?
- Fixed-width
- Delimited
- Fixed-width and delimited flat files that do not contain binary data
- Binary
16) Target Designer is used to :
- Import or create target definitions
- Create mappings
- Import or create source definitions
- Create target definitions
17) In which of the following ways can the target definitions be created ?
- Create a target definition based on a source definition
- Manually create a target definition
- Import the target definition from a relational target or a flat file
- All of the above
18) Which types of target definitions can be created in the Target Designer ?
- Relational
- Relational, Flat file, XML file
- Binary file
- DLL file
19) Mappings represent :
- the data flow between sources and targets
- data extraction
- data cleansing
- data loading
20) When the Integration Service runs a ……………, it uses the instructions configured in the mapping to read, transform, and write data
- command
- session
- transformation
- query
21) Every mapping must contain which of the following components :
- Source definition
- Target definition
- Source definition, Target definition, Transformation, Links
- Source and Target definition
22) Which of the following changes cause the session to be invalid ?
- Adding a table in the source database
- Deleting rows from a target table
- Creating an index in the source database
- Adding or removing a Joiner or Update Strategy transformation in the mapping
23) Which of the following cannot be used as Targets
- XML Files
- Cobol Files
- Text Files
- Relational Tables
24) A flat file cannot be used as the following
- Source
- Target
- Aggregator
- Lookup
25) Which of the following objects cannot be included in a mapplet?
- Target Definition
- Source Definitions
- Router Transformation
- Update Strategy Transformation
26) Shortcuts can be created from which of the following?
- Source Definitions
- Reusable transformations
- Mapplets
- All the above
27) Which of the following is not a Active Transformation ?
- Filter
- Sequence Generator
- Router
- Update Strategy
28) Which of the following Transformations does not use cache files ?
- Sorter
- Router
- Rank
- Aggregator
29) Which of the following is not a lookup cache property ?
- Dynamic Lookup Cache
- Static Lookup Cache
- Persistent Lookup Cache
- Active Lookup Cache
30) Which of the following transformations does not have variable port ?
- Expression
- Rank
- Filter
- Aggregator
31) The output from an Aggregator transformation without a Group by will return?
- All records
- Error
- 1 record
- None of the above
32) ………….. contains a set of transformations that can be reused in multiple mappings
- Worklet
- Mapplet
- Custom Transformation
- Workflow
33) An Active Transformation :
- Does not change the number of rows that pass through it
- Represents the data flow between sources and targets
- Can change the number of rows that pass through it
- Creates a target definition based on a source definition
34) When you add a relational or a flat file source definition to a mapping, you need to connect it to a
- Joiner Transformation
- Aggregator Transformation
- Source Qualifier Transformation
- Expression Transformation
35) In Joiner Transformation, if Master Outer Join type is used, it will :
- 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
- Discard all rows of data from the master and detail source that do not match, based on the condition
- 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
- Keep all rows of data from both the master and detail sources
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 ?
- Sorter Transformation
- Router Transformation
- Joiner Transformation
- Filter Transformation
37) A transformation that does not change the number of rows that pass through it, is called :
- Passive Transformation
- Connected Transformation
- Mapplet
- Source Qualifier
38) ……………….. is an example of Passive Transformation
- Update Strategy Transformation
- Router Transformation
- Expression Transformation
- Rank Transformation
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
- Sorter Transformation
- Update Strategy Transformation
- Joiner Transformation
- Normalizer Transformation
40) To concatenate first name and last name of an employee, which transformation would be used ?
- Aggregator Transformation
- Joiner Transformation
- Expression Transformation
- Normalizer Transformation
41) Aggregator Transformation performs :
- calculation of values in a single row
- concatenation of columns/ports in a row
- aggregate calculations, such as averages and sums
- calculations on a row-by-row basis
42) Which of the following is not True with respect to Sorter transformation ?
- Sorter uses cache memory to sort data
- Sorter is a Passive Transformation
- Sorter can be used to remove duplicate records
- All the above
43) What types of transformation ports are valid ones?
- Input, Output, Variable
- ans)Input, Output, Input/Output, Variable
- Input, Output, Variable, Aggregate
- Input, Output, Input/Output, Variable, Parameter
44) What value would the function GET_DATE_PART (DATE_SHIPPED, ‘HH’) return
when the value of DATE_SHIPPED is null?
- 0
- Null
- 12
- A Transformation error is generated
45) For triming leading & trailing spaces of a in Informatica the following function is used
- TRIM(VALUE)
- LTRIM(VALUE)
- LTRIM(RTRIM(VALUE))
- All of the above
46) A set of instructions to execute tasks such as sessions, emails, shell commands etc is called :
- Mapping
- Load Balancer
- Workflow
- Transformation
47) A session :
- is a set of instructions that describes how and when to execute tasks related to extraction, transformation and loading data
- is an object that groups a set of tasks
- is a set of instructions that describes how to move data from source to target using a mapping
- Reads workflow information from the repository
48) Which among the following is not a type of workflow task
- Event wait
- Event raise
- Timer
- Filter
49) A session task is a type of :
- transformation
- worklet
- workflow task
- mapplet
50) Chrological details of workflow tasks can be viewed in
- Gantt chart view
- task view
- Workflow view
- we cant view chronological details in worklow monitor
51) In a Workflow , you need to run an operating system script between two sessions. How can you best accomplish this?
- Call from Post SQL
- Call the script from a Command task
- Use a custom transformation
- Use Event raise and Event wait tasks
52) Are user-defined events supported in PowerCenter workflows?
- No, because only File Wait events are supported in the Event-Wait task.
- Yes, but only in workflows containing worklets.
- No, because Event-raise tasks do not support user-defined events.
- Yes, using a combination of Event-Raise and Event-Wait tasks
53) Which of the following is a type of workflow task?
- Database Bulk Loading
- Event Raise
- Ranking
- Sorting
54) A workflow fails and you need to consult the logs. Which PowerCener application will allow you consult the session and workflow logs?
- Designer
- Administration console.
- Workflow Monitor
- Workflow Manager.
55) A Workflow log does not contain which of the following?
- Status of tasks and worklets in the workflow
- Errors encountered during the workflow and general information
- Status of tasks and worklets in the workflow
- None of the above
56) To determine the cause of workflow or session problems & resolve it?
- Use log events
- Locate the relevant log codes
- Locate text prefixes
- All of the above
57) You can also create an _________ file for workflow log events
- XML
- text
- binary log
- All of the above
58) What is Default Recovery Strategy for Session
- Restart task
- Resume from last checkpoint
- Fail task and continue workflow
- None
59) At which tracing level does the Integration Service not write error messages or row-level information for reject data.
- Terse
- Verbose
- Both A and B
- Normal
60) You can view properties for which of the following items in the Workflow Monitor?
- Session, Tasks, Workflows
- Session, Tasks, Workflows, Links, Folders
- Session, Tasks, Workflows, Links, Folders, Integration Service
- Session, Tasks, Workflows, Links, Folders, Integration Service, Grids
61) which command is used to execute workflow tasks from the command line
- PMREP
- PMCMD
- REPCMD
- CMD
62) A scheduling tool from BMC software
- CONTROL M
- Autosys
63) -sv’ option of PMCMD command is used to specify______________ name
- repository service
- domain name
- integration service name
- node name