Sl.

no Topic Question OptA OptB OptC OptD Answer

1 Architecture Overview You define a set of instructions to execute tasks, using : Workflow Monitor Workflow Manager Repository Manager PowerCenter Designer
& Components B
2 Architecture Overview .……………….. is the primary unit for management and administration within Repository Manager Workflow Manager Administration Console Power Center Domain
& Components PowerCenter D
3 Architecture Overview A ……….. is the logical representation of a machine in a domain Node Server Grid Service A
& Components
4 Architecture Overview ………… allow users to create shortcuts to objects in the folder Integration Service Ans)Shared Folder Repository Security Administration Console B
& Components
5 Architecture Overview The Integration Service connects to the repository through the …………… to fetch Repository Service Repository Manager Reporting Service Metadata Manager Service
& Components metadata from the repository A
6 Architecture Overview Which among the following is not an Application service Integration service Repository service Log service reporting service
& Components C
7 Architecture Overview Which service is responsible for executing the mappings Integration service Repository service Log service reporting service
& Components A
8 Architecture Overview Which are the types of services which need not to be created by the Administrator? SAP BW service Core Repository service Application service
& Components B
9 Designer A set of source and target definitions linked by transformation objects that define the Mapping Worklet Workflow Schema
rules for data transformation is called a A
10 Designer …………… is a repository object that generates, modifies, or passes data Transformation DTM Mapping Integration Service Process A
11 Designer To create or import source definitions, ………….. is used in the Designer Target Designer Transformation Developer Mapping Designer Source Analyzer D
12 Designer 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 C
13 Designer Relational source definitions can be imported from : tables tables, views, synonyms tables, views tables, views, stored procedures D
14 Designer When a relational source definition is imported, which of the following source triggers stored procedures Column Names, Datatypes Column Names, Datatypes,
metadata is imported ? Key constraints D
15 Designer What type of files can be imported for flat-file source/target definitions in the Fixed-width Delimited Fixed-width and delimited flat files Binary
repository ? that do not contain binary data C
16 Designer Target Designer is used to : Import or create target definitions Create mappings Import or create source definitions Create target definitions A
17 Designer In which of the following ways can the target definitions be created ? Create a target definition based on a Manually create a target definition Import the target definition from a All of the above
source definition relational target or a flat file D
18 Designer Which types of target definitions can be created in the Target Designer ? Relational Relational, Flat file, XML file Binary file DLL file B
19 Designer Mappings represent : the data flow between sources and data extraction data cleansing data loading
targets A
20 Designer When the Integration Service runs a ……………, it uses the instructions configured in command session transformation query
the mapping to read, transform, and write data B
21 Designer Every mapping must contain which of the following components : Source definition Target definition Source definition, Target definition, Source and Target definition
Transformation, Links C
22 Designer 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 D
23 Designer Which of the following cannot be used as Targets XML Files Cobol Files Text Files Relational Tables B
24 Designer A flat file cannot be used as the following Source Target Aggregator Lookup C
25 Designer Which of the following objects cannot be included in a mapplet? Target Definition Source Definitions Router Transformation Update Strategy Transformation A
26 Designer Shortcuts can be created from which of the following? Source Definitions Reusable transformations Mapplets All the above D
27 Designer Which of the following is not a Active Transformation ? Filter Sequence Generator Router Update Strategy B
28 Designer Which of the following Transformations does not use cache files ? Sorter Router Rank Aggregator B
29 Designer Which of the following is not a lookup cache property ? Dynamic Lookup Cache Static Lookup Cache Persistent Lookup Cache Active Lookup Cache D
30 Designer Which of the following transformations does not have variable port ? Expression Rank Filter Aggregator C
31 Designer The output from an Aggregator transformation without a Group by will return? All records Error 1 record None of the above C
32 Designer ………….. contains a set of transformations that can be reused in multiple mappings Worklet Mapplet Custom Transformation Workflow B
33 Designer An Active Transformation : Does not change the number of rows Represents the data flow between Can change the number of rows that Creates a target definition based C
that pass through it sources and targets pass through it on a source definition
34 Designer When you add a relational or a flat file source definition to a mapping, you need to Joiner Transformation Aggregator Transformation Source Qualifier Transformation Expression Transformation C
connect it to a
35 Designer In Joiner Transformation, if Master Outer Join type is used, it will : Keep all rows of data from the Discard all rows of data from the Keep all rows of data from the master Keep all rows of data from both
detail source and the matching master and detail source that do not source and the matching rows from the the master and detail sources
rows from the master source, and match, based on the condition detail source, and discards the
discards the unmatched rows from unmatched rows from the detail source
the master source A
36 Designer To test data for one or more conditions and route rows of data that do not meet any of Sorter Transformation Router Transformation Joiner Transformation Filter Transformation B
the conditions to a default output group, which transformation would you use ?
37 Designer A transformation that does not change the number of rows that pass through it, is Passive Transformation Connected Transformation Mapplet Source Qualifier A
called :
38 Designer ……………….. is an example of Passive Transformation Update Strategy Transformation Router Transformation Expression Transformation Rank Transformation C
39 Designer ……………….. is used to control on a row by row basis, whether the row is to be Sorter Transformation Update Strategy Transformation Joiner Transformation Normalizer Transformation B
inserted, updated, deleted or a rejected based on some logical condition
40 Designer To concatenate first name and last name of an employee, which transformation would Aggregator Transformation Joiner Transformation Expression Transformation Normalizer Transformation C
be used ?
41 Designer Aggregator Transformation performs : calculation of values in a single row concatenation of columns/ports in a aggregate calculations, such as calculations on a row-by-row C
row averages and sums basis
42 Designer 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 All the above
records B
43 Designer What types of transformation ports are valid ones? Input, Output, Variable ans)Input, Output, Input/Output, Input, Output, Variable, Aggregate Input, Output, Input/Output, B
Variable Variable, Parameter
44 Designer What value would the function GET_DATE_PART (DATE_SHIPPED, 'HH') return 0 Null 12 A Transformation error is
B
when the value of DATE_SHIPPED is null? generated
45 Designer 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 C
46 Workflow manager A set of instructions to execute tasks such as sessions, emails, shell commands Mapping Load Balancer Workflow Transformation C
etc is called :
47 Workflow manager A session : is a set of instructions that describes is an object that groups a set of tasks is a set of instructions that describes Reads workflow information from C
how and when to execute tasks related how to move data from source to the repository
to extraction, transformation and target using a mapping
loading data
48 Workflow manager Which among the following is not a type of workflow task Event wait Event raise Timer Filter D
49 Workflow manager A session task is a type of : transformation worklet workflow task mapplet C
50 Workflow manager Chrological details of workflow tasks can be viewed in Gantt chart view task view Workflow view we cant view chronological details A
in worklow monitor
51 Workflow manager In a Workflow , you need to run an operating system script between two sessions. Call from Post SQL Call the script from a Command Use a custom transformation Use Event raise and Event wait
B
How can you best accomplish this? task tasks
52 Workflow manager Are user-defined events supported in PowerCenter workflows? No, because only File Wait events are Yes, but only in workflows containing No, because Event-raise tasks do not Yes, using a combination of
supported in the Event-Wait task. worklets. support user-defined events. Event-Raise and Event-Wait D
tasks
53 Workflow manager Which of the following is a type of workflow task? Database Bulk Loading Event Raise Ranking Sorting B
54 A workflow fails and you need to consult the logs. Which PowerCener application will Designer Administration console. Workflow Monitor Workflow Manager.
Workflow monitor C
allow you consult the session and workflow logs?
55 Status of tasks and worklets in the Errors encountered during the Status of tasks and worklets in the None of the above
Workflow monitor A Workflow log does not contain which of the following? D
workflow workflow and general information workflow
56 Workflow monitor 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 D
57 Workflow monitor You can also create an _________ file for workflow log events XML text binary log All of the above D
58 Workflow monitor What is Default Recovery Strategy for Session Restart task Resume from last checkpoint Fail task and continue workflow None c
59 At which tracing level does the Integration Service not write error messages or Terse Verbose Both A and B Normal
Workflow monitor a
row-level information for reject data.
60 Session, Tasks, Workflows Session, Tasks, Workflows, Links, Session, Tasks, Workflows, Links, Session, Tasks, Workflows,
Workflow monitor You can view properties for which of the following items in the Workflow Monitor? Folders Folders, Integration Service Links, Folders, Integration D
Service, Grids
61 scheduling which command is used to execute workflow tasks from the command line PMREP PMCMD REPCMD CMD B
62 scheduling A scheduling tool from BMC software CONTROL M Autosys A
63 scheduling -sv' option of PMCMD command is used to specify______________ name repository service domain name integration service name node name C
 SL No Topic Question Opt A Opt B Opt C Opt D Answer
designer
How many return ports are allowed in unconnected
2 1 3 Any number
B
1 lookup transformation ?
designer
which reference is used to call an unconnected lookup
:LKP :LPK LKP no reference is required
A
2 transformation?
designer
the transformation that control how the rows are flagged
Router Lookup Update Strategy Filter
C
3 for Insert, Update, Reject or Delete in a Mapping
Informatica The kinds of information that are stored in the repository
Repository configuration details Mappings Workflows All of the above
D
4 Repository are
Informatica Which PowerCenter applications are used for creating Administration Console and Repository Manager and Workflow Manager and Workflow
Designer and Workflow Manager.
B
5 Repository and administrating folders? Workflow manager Administration Console Monitor
Informatica The dependency window can display following type of
source target dependencies Mapping dependencies shortcut dependencies All of the above
D
6 Repository dependency
Informatica Which types of objects can be visible in the Repository Mappings, repository users, and
Repository users, folders and Business
Mappings and Mapplets,Integration
C
sub folders ,and source and components,Mappings,reusable
Repository Manager Navigator window? source and target definitions Services,and folders and subfolders
7 target definitions transformations
Partitions in
One of the following partition types available to D
Informatica ensures that data is evenly distributed among Hash partitioning n:n Master/Detail partitioning Keyrange partitioning Round-robin partitioning
Informatica
8 all partitions
Partitions in If you have created a session using source-based B
commit, which partition type do you use on the Round-Robin Partitioning Pass-Through Data-Driven Hash User-Keys
Informatica
9 Relational and Flat File targets?
Partitions in single reader, transformation, or multiple reader, transformation, or
single reader, multiple A
A partition executes in a _________ single reader, or writer thread transformation, or multiple writer
Informatica writer thread writer thread
10 thread
Partitions in Which partition type need to be used if the target tables
round robin Hash auto keys Key Range database
C
11 Informatica are partitioned on key range
Multiple partitions for a single D
pipeline stage, Partitioning How the Integration Service reads
Partitions in Number of source and target
Partitioning option helps configure which of the following? information that controls the data from the source, distributes All of the above
Informatica connections to use
number of threads (reader, rows of data to each transformation
12 transformation, and writer)
Partitions in You cannot create partition point for which of the following
Source Qualifier Joiner Sequence Generator Both A & C
c
13 Informatica transformations
The integration service passes all The integration service passes
The integration service
c
Partitions in Which of the following is true in case of a Round Robin rows at one partition point to the the data to each partition The integration service distributes
distributes data evenly among
Informatica partitioning type next partition point without depending on the ranges you data to the partitions by group
all partitions
14 redistributing them specify for each port
Partitions in
Which is not a type of partition? Round robin database pass through key hash
D
15 Informatica
Partitions in Which of following changes to mappings can cause Delete a transformation that was a
Add a transformation that is a Move a transformation that is a
All of the above
D
16 Informatica partitioned session failure? partition point default partition point partition point to a different pipeline
Parameters & You can change the parameter file
You cannot change the
once a parameter file is created, it parameter files can be created
B
Which of the below statements is true? parameter file when the
Variables when the workflow is running can never be changed. dynamically
17 workflow is running
A parameter value can change
A parameter value remains
A parameter value must be read
A mapping variable value must be B
constant throughout a read from a flat file, and a
Parameters & What is the difference between a mapping parameter and throughout a Session Task run, and from a flat file, and a mapping
Session Task run, and a parameter value must be
Variables a mapping variable? a mapping variable value remains variable value must be recalculated
mapping variable value can recalculated with an expression for
constant. with an expression for each row.
18 change. each row.
Parameters &
Parameters are created in which tool? Repository manager Designer workflow monitor Admin console
B
19 Variables
$$$SessionStartTime returns the $$$SessionStartTime returns the
$$$SessionStartTime returns the
A
session start time as a string , session start time as integer , There is no difference in
Parameters & What is the difference between the system variables $$ session start time as a string , and
and SESSSTARTTIME returns and SESSSTARTTIME returns practice.Either can be used to
Variables $SessionStartTime and SESSSTARTTIME? SESSSTARTTIME returns the
the session start time as date/ the session start time as date/ return the session start time.
session start time as integer
20 time time
Parameters & Which among these is not a task specific predefined
Condition EndTime ErrorCode ErrorName
d
21 Variables workflow variable?
Parameters &
$$$SessStartTime cannot be
SESSSTARTTIME can be used $$$SessStartTime can be used in
a
Which is not true about built in functions
use in Mapping or mapplet filter NONE
Variables $$$SessStartTime and SESSSTARTTIME ? in expressions. sql overrides.
22 condition.
Values can be defined for b
Parameters & Built-in variables return either built-in variables in a The integration service sets the Built-in variables can be used in
Which options is false for built-in-variables:
Variables run-time or system information workflow or session values for built in variables. expressions in Designer.
23 parameter file.
1. Value in parameter file
1. Value saved in the repository
1. Datatype default value 1. User-specified default value a
2. Value saved in the repository 2. Value saved in the repository (if 2. Datatype default value
The Integration Service looks for the start value of a (if the variable is persistent)
Parameters & (if the variable is persistent) the variable is persistent) 3. Value saved in the repository (if
variable in the following order: 2. Value in parameter file
Variables 3. User-specified default value 3. Value in parameter file the variable is persistent)
3. User-specified default value
4. Datatype default value 4. User-specified default value 4. Value in parameter file
4. Datatype default value
24
Parameters &
which among the following is not a variable function? SetMaXVariable SetMinVariable SetCountVariable SetAvgVariable
D
25 Variables
Parameters &
If we enter a space between the parameter name and a
the equals sign, the Integration Service interprets the part of the parameter name part of the parameter value Ignores it Throws an error
Variables
26 space as
Parameters & What is difference between $ and $$ parameters/ $ are User defined and $$ are $ are System defined and $$ $ are Session Level defined and $$ $ are Mapping Level defined and $$ b
27 Variables variables? System defined variables are User defined variables are Mapping Level defined variables are Session Level defined variables
Parameters & To assign a null value to $PMBadFileDir , set the
$PMBadFileDir=NULL $ PMBadFileDir=’\0’ $PMBadFileDir=<null> None of the Above
c
28 Variables parameter or variable value to
Mapplets and mapplet ports If you use a Sequence
A mapplet can be active or
d
Reuable display differently in the Mapplet Generator transformation, you COBOL Sources and XML
Which of the below statement is not true about Mapplet passive depending on the
components Designer and the Mapping must use a reusable Sequence Sources can be used in mapplet
transformations in the mapplet
29 Designer Generator transformation
Reuable Which of the below statement about reusable component We can revert back Reusable
We cannot revert back Reusable components are only once a reusable component is B
Reusable transformation to created in the mapping designer created, we need to use only that in
components is true? transformation to normal one
30 normal one tool all the mappings
Which of the below object cannot be used in Mapplet.
1. Expression Transformation
2. Lookup Transformation
Reuable
3. Normalizer transformation 1&2 2&3 3&4 4 C
components
4. Mapplet

31
Reuable A mapplet must contain at least one _____ with at least
Input Transformation Ouput Transformation Sequence Generator None
b
33 components one connected port in the mapplet.
Which of the following actions when performed on a
Do not change the data type,
d
mapplet can cause an existing mappings to become Do not change a passive mapplet
Reuable Do not delete connected ports in precision, or scale of connected
invalid? to an active mapplet or an active All of the above
components an Input or Output transformation ports in an Input or Output
mapplet to a passive mapplet.
transformation
34
Reuable A mapplet used to run a batch of
A mapplet is a reusable
A mapplet is a database object
B
What is a mapplet? object that is created using None of the above
components mappings referred in a mapping
35 mapplet designer.
Reuable Which statement is true of Worklets but NOT of
They encapsulate part of the D
They are reusable by nature functionality of a Workflow/ They have their own Designer tool They can be nested
components Mapplets?
36 Mapping
Reuable Which is not a valid option of UPDATE STRATEGY
DD_DELETE DD_INSERT DD_UPDATE DD_TRUNCATE
D
37 components transformation
Reuable If you delete ports in the mapplet when the mapplet is
It invalidates the mapping
It does not invalidate the
It will invalidate the mapplet None of the above
A
38 components used in a mapping, which of the following is True? mapping
Reuable which of the transformation cannot be created as
sequence genertor Source qualifier sorter expression
B
39 components Reusable transformation?
Reuable
_____________ definitions are not allowed in mapplet Target source trasnformation None of the Above
A
40 components
What happens if the Lookup table is larger than the
the Power Center Server stores A
Debugging Job the overflow values in the The workflow execution will fail The workflow will execute with error the system will hang
Lookup Cache?
41 cache files
The Designer and the Workflow The Designer and a running
The Designer, the Workflow C
Debugging Job Which components are required to run a debug session? The Designer Manager, and a running Informatica
Manager Informatica server
42 server
Debugging Use an existing non-reusable Use an existing reusable
What type of debugger sessions can be configured? Create a debug session instance All of the above D A
43 Job session session
SCD What is a conformed dimension? Dimesion which is finalized.
Dimesion which is connected Dimesion which is connected to Dimesion which is connected to B
44 to more than one fact. another dimention. single fact
45 SCD Which is not a Valid SCD type 2? Flag Date Range Version and) Type C
46 SCD Which SCD type stored Partial history? SCD type1 SCD Type 2 SCD Type 3 None of the Above C
47 SCD Which type of SCD can store the complete history SCD type1 SCD Type 2 SCD Type 3 None of the Above B
Session Which is not a valid options in Target Load type
BULK NORMAL FULL A&B
B
48 Properties Property?
The tasks that can be performed using Workflow
Create sessions, view object Create and delete workflows,
Create and delete workflows,
Create and Edit tasks, Start and B
Job Execution dependencies, run workflows, edit configure connections, create stop Informatica server, monitor
Manager create tasks, restore repositories
49 mappings tasks workflows
Job Execution Which one of the following statements is NOT correct?
Workflows must be within Tasks Tasks must be within Workflows Workflow links may contain
Workflows may contain worklets.
A
50 to be executed to be executed conditions
198 Job Execution Which of the following is a type of workflow task? Database Bulk Loading Event Raise Ranking Sorting B A

Job Execution
How to run a workflow without using GUI i.e, Workflow
From Oracle Database Using 'runworkflow' command Using pmcmd command None of the above
C
51 Manager, Workflow Monitor?
Job Execution
In a sequential batch, can we run the session if previous Yes, the second session will run the second session has no We cannot run sessions the second session will by default A
52 session fails? even if the first session fails dependency of the first session sequentially in workflow manager fail if the first session fails
If a session fails after loading of 10000 records into the
Restart the session using Restart the session using workflow It is not possible to load from
B
Job Execution target. How can you load the records from 10001th Restart the session normally
session recovery option manager option 10001th record
53 record when you run the session next time?
Job Execution Difference between stop and abort
Stop - Stops the Session Stop - Kills the session.
Both stops the session None of the above
A
54 Abort - Kills the session. Abort - Stops the session
Job Execution
Which command line program should you use to start a
infacmd infasetup pmrep pmcmd
D
55 workflow from a batch file?
56 Job Schedule Which of the following objects can be scheduled? Workflows Sessions Worklets Command Tasks A
scheduling
which command is used to execute workflow tasks from
PMREP PMCMD REPCMD CMD
B
57 the command line
58 scheduling A scheduling tool from BMC software and) CONTROL M Autosys workflow scheduler Maestro A
Job Process
How to determine whether the incoming record already
Using Router Transformation Using Lookup Transformation Using Aggregate Transformation Writing a select query on toad
B
59 exists in the target table?
source qualifier ,all the
source qualifier and all the
source qualifier ,all the A
transformations and targets that transformations and all the targets
Job Process A pipeline consists of a ______ transformations from that source none of the above
receive data from that source in the mapping from other sources
qualifier but not target
60 qualifier as well
SL
Topic Question Opt A Opt B Opt C Opt D Answer
No
Which of the following is a Web Based application for administering
1 Repository service Repository Manager ans)Admin console repository service integration service B
the powercenter domain and powercenter security
2 Repository service which is not the valid kind on lock on repository objects Read lock write lock execute lock Exclusive lock D
any extension can be
3 Repository service the extension of a repository backup file is .REP .BAK .DBF A
given
The Designer, the
The Designer and a
The Designer and the Workflow Manager,
4 Debugging Job Which components are required to run a debug session? The Designer running Informatica C
Workflow Manager and a running
server
Informatica server
Use an existing non-reusable Use an existing reusable Create a debug session
5 Debugging Job What type of debugger sessions can be configured? All of the above D
session session instance
6 scheduling A scheduling tool from BMC software CONTROL M Autosys workflow scheduler Maestro A
Transformation
pushdown Source side Pushdown Target side Pushdown Full Pushdown
7 Which is not a Type of Pushdown optimization: Pushdown d
optimization optimization optimization optimization
optimization
pushdown For pushdown optimization the integration service creates which Update,insert,Delete
8 insert statement Select insert statement Select statement c
optimization DML in case of source side pushdown? statement
Transforms
Transforms Mapplet logic into Transforms Session logic
pushdown Transformation logic
9 What is 'PowerCenter Pushdown Optimization Option' in Informatica SQL Queries and sends to into SQL Queries and sends None B
optimization into SQL Queries and
database to database
sends to database
pushdown
10 Types of Pushdown optimizations Source-side push down Target side push down Full push down All D
optimization
pushdown For pushdown optimization the integration service creates which Update,insert,Delete
11 select update statement Select insert statement Select statement D
optimization DML in case of target side pushdown? statement
When the Integration
Service pushes
integration service cannot
pushdown transformation logic to the integration service can also all above statements
12 Which statement about integration service is true? push transformation logic to A
optimization database, it cannot track track database errors are valid
the database
errors that occur in the
database
pushdown To use different pushdown optimization configuration at different
13 $$configpushdown $$Pushdownconfig $$pushdownsource $$pushdowntarget B
optimization times, use the ________________ mapping parameter
database, transformation database, transformation transformation logic,
pushdown In Pushdown Optimization the amount of transformation logic that transformation logic, and
14 logic, mapping and session logic and mapping mapping and session A
optimization can be pushed to the database depends on the ___________ mapping configuration
configuration configuration configuration
Is a session property
Optimizing the workflow
pushdown Optimizing the session Optimizing the lookup to pushdown the
15 Pushdown Optimization is used for performance while D
optimization performance while execution performance transformation logic to
executing
the database
Immediately before an
Performance To improve performance, where should a filter transformation be As early in the mapping as As late in the mapping as Immediately before an
16 Expression A
Tuning placed? possible. possible. Aggregator transformation.
transformation.
Drop the constraints and
indexes should be dropped disable the
indexes before running
Performance indexes need to be enabled but constraints should be constraints but enable
17 Which of the below statements helps in improving the performance the session and rebuild B
Tuning before running a session enabled before running a the indexes before
them after completion of
session running a session
session
Performance How to improve the session performance in aggregator
18 Using Sorted Input Using Index Using SQL Override None of the above A
Tuning transformation?
sort the detail data
Performance Make the smaller source the Make the smaller source Sort the master data prior to
19 How can you minimize the cache for a joiner transformation? prior to the joiner A
Tuning master source the details source the joiner transformation
transformation
When you want to create an additional pipeline stage to improve
Performance
20 performance, but do not want to change the distribution of data Database Key range Hash user keys Pass-through D
Tuning
across partitions, use _______ partition
When multiple tasks are
waiting to be dispatched,
Load Balancer dispatches You can create service
Performance the Load Balancer
21 Which of the following is True on Load Balancing? tasks from the dispatch queue levels and configure the All of the above D
Tuning dispatches high priority
based on the service levels dispatch priorities
tasks before low priority
tasks
The transformation logic The session is not
Performance Integration Service processes the transformation logic if which of the updates a mapping variable and The transformation configured to override the
22 a&b d
Tuning following conditions are true: saves it to the repository contains a variable port. default values of input or
database output ports.
Location of the Mapping and session
Performance Which of the following criteria affects whether the Integration Service
23 Type of transformation transformation in the configuration for the All of the above d
Tuning can push the transformation to the database?
mapping transformation
Performance SQL queries or messages
24 Pushdown optimization viewer shows. ETL logic Transformation details None of the above C
Tuning related to the pushdown
Performance
25 Pushdown optimization cannot be used on which transformation? Source Qualifier Target Rank Union C
Tuning
When the Integration When the Integration When the Integration Service
Service spends more time on Service spends more time spends more time on the All above statements
Performance
26 When can you say that there is a source bottleneck? the reader thread than the on the transformation writer thread than the create source A
Tuning
transformation or writer thread than the reader or transformation or reader bottleneck
threads writer threads threads
String operations are faster than You should trim char and ans)The CONCAT function Using a variable is C
number operations varchar fields before is faster than the || less efficient than
Performance You are optimizing a mapping. Which of the following statements
27 performing comparisons. operator using the equivalent
Tuning about expressions is true?
code in several
expressions.
Performance Configure for Single-Pass Avoid unnecessary Avoid database reject errors All the above D
28 Which statement about optimizing Mapping bottleneck are valid?
Tuning reading datatype conversions statements are valid
The______ratio indicates the number of read or write operations the
Performance
29 Integration Service performs on the cache. hit ratio miss ratio a&b None of the Above A
Tuning
Performance [(# of reads from disk) + (# of writes to disk)]/[(# of reads from
30 hit ratio miss ratio a&b None of the Above A
Tuning memory cache) + (# of writes to memory cache)] is the formula for
Performance check hard disks on
31 Which is not valid for optimizing system bottleneck? Improve network speed improve CPU performance increase paging C
Tuning related machines
___________is a PowerCenter web application to browse,analyze informatica Metadata
32 Metadata Manager informatica IDQ informatica powerexchange Informatica MDM C
and manage metadata form disparate sources Manager
________ is used to analyze where data originates, how the data is
33 Metadata Manager impact Analysis Data Lineage data depenedency data quality B
transformed and what objects transform it, and where the data ends
which repository table stores the name of each PowerCenter
34 Repository tables OPB_MAPPING OPB_TASK OPB_FOLDER OPB_SUBJECT
repository folder D
The repository table thast stores the names and IDs of all the
35 Repository tables OPB_MAPPING OPB_TASK
transformation fields for each of the transformations OPB_WIDGET_FIELD OPB_COLUMNS C
The repository table which stores the component details like
36 Repository tables Post-Session-Success-Email, commands in Post-Session/ OPB_COMPONENT OPB_SESSIONS OPB_TASK_ATTR OPB_REPO A
pre-Session etc
Which repository table stores information regarding repository name OPB_REPOSIT A
37 Repository tables OPB_SESSIONS OPB_TASK_ATTR OPB_REPO
and its associated domain
This table stores the details of the expressions used anywhere in C
38 Repository tables OPB_MAPPING OPB_TASK OPB_EXPRESSION OPB_DETAILS
PowerCenter
The repository table that stores the name and ID of each mapping A
39 Repository tables OPB_MAPPING OPB_TASK OPB_EXPRESSION OPB_DETAILS
and its corresponding folder
integration with Which plug in enables IT to access and extract data from social PowerExchange for Social Powerexchange for
40 PowerExchange No plug in is required A
social media media networks and integrate data in batch or real time Media twitter