How many return ports are allowed in unconnected lookup transformation ?
2
1 3 Any number.
which reference is used to call an unconnected lookup transformation?
:LKP
:LPK LKP no reference is required.
the transformation that control how the rows are flagged for Insert, Update, Reject or Delete in a Mapping
Router
Lookup Update Strategy Filter.
The kinds of information that are stored in the repository are
Repository configuration details
Mappings Workflows All of the above.
Which PowerCenter applications are used for creating and administrating folders?
Administration Console and Workflow manager Repository Manager and Administration Console Workflow Manager and Workflow Monitor Designer and Workflow Manager.
The dependency window can display following type of dependency
source target dependencies Mapping dependencies shortcut dependencies All of the above.
Which types of objects can be visible in the Repository Manager Navigator window?
Mappings, repository users, and source and target definitions
Repository users, folders and sub folders ,and source and target definitions
Business components,Mappings,reusable transformations
Mappings and Mapplets,Integration Services,and folders and subfolders
.
One of the following partition types available to Informatica ensures that data is evenly distributed among all partitions
Hash partitioning n:n Master/Detail partitioning Keyrange partitioning Round-robin partitioning
.
If you have created a session using source-based commit, which partition type do you use on the Relational and Flat File targets?
Round-Robin Partitioning
Pass-Through Data-Driven Hash User-Keys .
A partition executes in a _________
single reader, transformation, or writer thread single reader, or writer thread multiple reader, transformation, or writer thread single reader, multiple transformation, or multiple writer thread
.
Which partition type need to be used if the target tables are partitioned on key range
round robin
Hash auto keys Key Range database.
Partitioning option helps configure which of the following?
Multiple partitions for a single pipeline stage, Partitioning information that controls the number of threads (reader, transformation, and writer)
Number of source and target connections to use
How the Integration Service reads data from the source, distributes rows of data to each transformation
All of the above
.
You cannot create partition point for which of the following transformations
Source Qualifier Joiner Sequence Generator Both A & C.
Which of the following is true in case of a Round Robin partitioning type
The integration service passes all rows at one partition point to the next partition point without redistributing them The integration service passes the data to each partition depending on the ranges you specify for each port The integration service distributes data evenly among all partitions The integration service distributes data to the partitions by group.
Which is not a type of partition?
Round robin
database pass through key hash.
Which of following changes to mappings can cause partitioned session failure?
Delete a transformation that was a partition point Add a transformation that is a default partition point Move a transformation that is a partition point to a different pipeline All of the above.
Which of the below statements is true?
You can change the parameter file when the workflow is running
You cannot change the parameter file when the workflow is running once a parameter file is created, it can never be changed. parameter files can be created dynamically.
What is the difference between a mapping parameter and a mapping variable?
A parameter value can change throughout a Session Task run, and a mapping variable value remains constant.
A parameter value remains constant throughout a Session Task run, and a mapping variable value can change.
A parameter value must be read from a flat file, and a mapping variable value must be recalculated with an expression for each row.
A mapping variable value must be read from a flat file, and a parameter value must be recalculated with an expression for each row.
.
Parameters are created in which tool?
Repository manager Designer workflow monitor Admin console.
What is the difference between the system variables $$$SessionStartTime and SESSSTARTTIME?
$$$SessionStartTime returns the session start time as a string , and SESSSTARTTIME returns the session start time as date/time
$$$SessionStartTime returns the session start time as integer , and SESSSTARTTIME returns the session start time as date/time
$$$SessionStartTime returns the session start time as a string , and SESSSTARTTIME returns the session start time as integer
There is no difference in practice.Either can be used to return the session start time.
.
Which among these is not a task specific predefined workflow variable?
Condition
EndTime ErrorCode ErrorName.
Which is not true about built in functions $$$SessStartTime and SESSSTARTTIME ?
$$$SessStartTime cannot be use in Mapping or mapplet filter condition.
SESSSTARTTIME can be used in expressions. $$$SessStartTime can be used in sql overrides. NONE.
Which options is false for built-in-variables:
Built-in variables return either run-time or system information Values can be defined for built-in variables in a workflow or session parameter file. The integration service sets the values for built in variables. Built-in variables can be used in expressions in Designer.
"The Integration Service looks for the start value of a variable in the following order:" "1. Value in parameter file
2. Value saved in the repository (if the variable is persistent)
3. User-specified default value
4. Datatype default value
" "1. Value saved in the repository (if the variable is persistent)
2. Value in parameter file
3. User-specified default value
4. Datatype default value" "1. Datatype default value
2. Value saved in the repository (if the variable is persistent)
3. Value in parameter file
4. User-specified default value
" "1. User-specified default value
2. Datatype default value
3. Value saved in the repository (if the variable is persistent)
4. Value in parameter file
".
which among the following is not a variable function?
SetMaXVariable
SetMinVariable SetCountVariable SetAvgVariable.
If we enter a space between the parameter name and the equals sign, the Integration Service interprets the space as
part of the parameter name part of the parameter value Ignores it Throws an error.
What is difference between $ and $$ parameters/variables?
$ are User defined and $$ are System defined variables $ are System defined and $$ are User defined variables $ are Session Level defined and $$ are Mapping Level defined variables $ are Mapping Level defined and $$ are Session Level defined variables.
To assign a null value to $PMBadFileDir , set the parameter or variable value to
$PMBadFileDir=NULL
$ PMBadFileDir=’\0’ $PMBadFileDir=<null> None of the Above.
Which of the below statement is not true about Mapplet
Mapplets and mapplet ports display differently in the Mapplet Designer and the Mapping Designer If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation A mapplet can be active or passive depending on the transformations in the mapplet COBOL Sources and XML Sources can be used in mapplet.
Which of the below statement about reusable component is true? We can revert back Reusable transformation to normal one We cannot revert back Reusable transformation to normal one Reusable components are only created in the mapping designer tool once a reusable component is created, we need to use only that in all the mappings.
"Which of the below object cannot be used in Mapplet.
1. Expression Transformation
2. Lookup Transformation
3. Normalizer transformation
4. Mapplet" 1&2 2&3 3&4 4.
A mapplet must contain at least one _____ with at least one connected port in the mapplet. Input Transformation
Ouput Transformation Sequence Generator None.
"Which of the following actions when performed on a mapplet can cause an existing mappings to become invalid?" Do not delete connected ports in an Input or Output transformation Do not change the data type, precision, or scale of connected ports in an Input or Output transformation Do not change a passive mapplet to an active mapplet or an active mapplet to a passive mapplet. All of the above
.
What is a mapplet?
A mapplet used to run a batch of mappings
A mapplet is a reusable object that is created using mapplet designer. A mapplet is a database object referred in a mapping None of the above.
Which statement is true of Worklets but NOT of Mapplets?
They are reusable by nature
They encapsulate part of the functionality of a Workflow/Mapping They have their own Designer tool They can be nested.
Which is not a valid option of UPDATE STRATEGY transformation
DD_DELETE
DD_INSERT DD_UPDATE DD_TRUNCATE.
If you delete ports in the mapplet when the mapplet is used in a mapping, which of the following is True?
It invalidates the mapping
It does not invalidate the mapping It will invalidate the mapplet None of the above.
which of the transformation cannot be created as Reusable transformation?
sequence genertor
Source qualifier sorter expression.
_____________ definitions are not allowed in mapplet
Target
source trasnformation None of the Above.
What happens if the Lookup table is larger than the Lookup Cache?
the Power Center Server stores the overflow values in the cache files
The workflow execution will fail The workflow will execute with error the system will hang.
Which components are required to run a debug session?
The Designer The Designer and the Workflow Manager The Designer and a running Informatica server The Designer, the Workflow Manager, and a running Informatica server
.
What type of debugger sessions can be configured?
Use an existing non-reusable session Use an existing reusable session Create a debug session instance All of the above.
What is a conformed dimension? Dimesion which is finalized. Dimesion which is connected to more than one fact. Dimesion which is connected to another dimention. Dimesion which is connected to single fact.
Which is not a Valid SCD type 2?
Flag
Date Range Version Type.
Which SCD type stored Partial history? SCD type1
SCD Type 2 SCD Type 3 None of the Above.
Which type of SCD can store the complete history SCD type1 SCD Type 2 SCD Type 3 None of the Above.
Which is not a valid options in Target Load type Property? BULK NORMAL FULL A & B.
The tasks that can be performed using Workflow Manager Create sessions, view object dependencies, run workflows, edit mappings
Create and delete workflows, configure connections, create tasks
Create and delete workflows, create tasks, restore repositories
Create and Edit tasks, Start and stop Informatica server, monitor workflows
.
Which one of the following statements is NOT correct?
Workflows must be within Tasks to be executed Tasks must be within Workflows to be executed Workflow links may contain conditions Workflows may contain worklets. .
Which of the following is a type of workflow task? Database Bulk Loading
Event Raise Ranking Sorting.
How to run a workflow without using GUI i.e, Workflow Manager, Workflow Monitor?
From Oracle Database Using 'runworkflow' command Using pmcmd command None of the above.
In a sequential batch, can we run the session if previous session fails? Yes, the second session will run even if the first session fails
the second session has no dependency of the first session We cannot run sessions sequentially in workflow manager the second session will by default fail if the first session fails.
If a session fails after loading of 10000 records into the target. How can you load the records from 10001th record when you run the session next time? Restart the session normally
Restart the session using session recovery option Restart the session using workflow manager option It is not possible to load from 10001th record.
Difference between stop and abort "Stop - Stops the Session
Abort - Kills the session. " "Stop - Kills the session.
Abort - Stops the session" Both stops the session None of the above.
Which command line program should you use to start a workflow from a batch file? infacmd infasetup pmrep pmcmd.
Which of the following objects can be scheduled? Workflows Sessions Worklets Command Tasks.
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 workflow scheduler Maestro.
How to determine whether the incoming record already exists in the target table? Using Router Transformation
Using Lookup Transformation Using Aggregate Transformation Writing a select query on toad.
A pipeline consists of a ______ source qualifier ,all the transformations and targets that receive data from that source qualifier source qualifier and all the transformations from that source qualifier but not target source qualifier ,all the transformations and all the targets in the mapping from other sources as well none of the above.
|
