.……………….. is the primary unit for management and administration within PowerCenter
Repository Manager
Workflow Manager Administration Console Power Center Domain
. A ……….. is the logical representation of a machine in a domain
Node Server Grid Service. ………… allow users to create shortcuts to objects in the folder
Integration Service Shared Folder Repository Security
Administration Console. The Integration Service connects to the repository through the …………… to fetch metadata from the repository
Repository Service
Repository Manager
Reporting Service
Metadata Manager Service
. Which among the following is not an Application service
Integration service
Repository service
Log service
reporting service
. Which service is responsible for executing the mappings
Integration service
Repository service
Log service
Reporting service
. Which are the types of services which need not to be created by the Administrator?
SAP BW service
Core Repository service
Application service
. 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
. …………… is a repository object that generates, modifies, or passes data
Transformation
DTM
Mapping Integration Service Process. To create or import source definitions, ………….. is used in the Designer
Target Designer
Transformation Developer Mapping Designer Source Analyzer. 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
. Relational source definitions can be imported from :
tables tables, views, synonyms tables, views tables, views, stored procedures
. 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. 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. Target Designer is used to :
Import or create target definitions
Create mappings Import or create source definitions Create target definitions. 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 . You define a set of instructions to execute tasks, using :
Workflow Monitor
Workflow Manager
Repository Manager
PowerCenter Designer
. Which types of target definitions can be created in the Target Designer ?
Relational
Relational, Flat file, XML file Binary file DLL file. Mappings represent :
the data flow between sources and targets
data extraction data cleansing data loading. When the Integration Service runs a ……………, it uses the instructions configured in the mapping to read, transform, and write data
command
session transformation query. Every mapping must contain which of the following components :
Source definition Target definition Source definition, Target definition, Transformation, Links
Source and Target definition. 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. Which of the following cannot be used as Targets
XML Files
Cobol Files Text Files Relational Tables. A flat file cannot be used as the following
Source
Target Aggregator Lookup. Which of the following objects cannot be included in a mapplet?
Target Definition
Source Definitions Router Transformation Update Strategy Transformation. Shortcuts can be created from which of the following?
Source Definitions
Reusable transformations Mapplets All the above. Which of the following is not a Active Transformation ?
Filter Sequence Generator Router Update Strategy
. Which of the following Transformations does not use cache files ?
Sorter
Router Rank Aggregator. Which of the following is not a lookup cache property ?
Dynamic Lookup Cache
Static Lookup Cache Persistent Lookup Cache Active Lookup Cache. Which of the following transformations does not have variable port ?
Expression
Rank Filter Aggregator. The output from an Aggregator transformation without a Group by will return?
All records Error 1 record None of the above
. ………….. contains a set of transformations that can be reused in multiple mappings
Worklet
Mapplet Custom Transformation Workflow. 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. 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. 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 . 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. A transformation that does not change the number of rows that pass through it, is called :
Passive Transformation
Connected Transformation Mapplet Source Qualifier. ……………….. is an example of Passive Transformation
Update Strategy Transformation
Router Transformation Expression Transformation Rank Transformation. ……………….. 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. To concatenate first name and last name of an employee, which transformation would be used ?
Aggregator Transformation Joiner Transformation Expression Transformation
Normalizer Transformation. 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. 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. What types of transformation ports are valid ones?
Input, Output, Variable
Input, Output, Input/Output, Variable Input, Output, Variable, Aggregate Input, Output, Input/Output, Variable, Parameter. "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. 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. A set of instructions to execute tasks such as sessions, emails, shell commands etc is called :
Mapping
Load Balancer Workflow Transformation. 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
. Which among the following is not a type of workflow task
Event wait
Event raise Timer Filter. A session task is a type of :
transformation
worklet workflow task mapplet. Chrological details of workflow tasks can be viewed in
Gantt chart view
task view Workflow view we cant view chronological details in worklow monitor. 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. 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
. Which of the following is a type of workflow task?
Database Bulk Loading
Event Raise Ranking Sorting. 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. 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. 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. You can also create an _________ file for workflow log events
XML
text binary log All of the above. What is Default Recovery Strategy for Session
Restart task
Resume from last checkpoint Fail task and continue workflow None. 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. 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
. which command is used to execute workflow tasks from the command line
PMREP
PMCMD REPCMD CMD. A scheduling tool from BMC software
CONTROL M
Autosys. -sv' option of PMCMD command is used to specify______________ name
repository service domain name integration service name node name
.
|