Hello friends in this post we are going to discuss about Informatica Multiple choice question | Informatica Objective type question | Informatica MCQ Question Answer | Informatica Wipro Myskillz Trendnxt Answers
If you are looking for more Dumps for MYSKILLZ Visit Here
How many return ports are allowed in unconnected lookup transformation ?
1
which reference is used to call an unconnected lookup transformation?
LKP
the transformation that control how the rows are flagged for Insert, Update, Reject or Delete in a Mapping
Update Strategy
The kinds of information that are stored in the repository are
Repository configuration details, Mappings, Workflows
Which PowerCenter applications are used for creating and administrating folders?
Repository Manager and Administration Console
The dependency window can display following type of dependency
source target dependencies, Mapping dependencies, shortcut dependencies
Which types of objects can be visible in the Repository Manager Navigator window?
Business components,Mappings,reusable transformations
One of the following partition types available to Informatica ensures that data is evenly distributed among all partitions
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?
Pass-Through
A partition executes in a _______
single reader, transformation, or writer thread
Which partition type need to be used if the target tables are partitioned on key range
Key Range
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
You cannot create partition point for which of the following transformations
Sequence Generator
Which of the following is true in case of a Round Robin partitioning type
The integration service distributes data evenly among all partitions
Which is not a type of partition?
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
Which of the below statements is true?
You cannot change the parameter file when the workflow is running
What is the difference between a mapping parameter and a mapping variable?
A parameter value remains constant throughout a Session Task run, and a mapping variable value can change.
Parameters are created in which tool?
Designer
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
Which among these is not a task specific predefined workflow variable?
ErrorName
Which is not true about built in functions $$$SessStartTime and SESSSTARTTIME ?
$$$SessStartTime cannot be use in Mapping or mapplet filter condition.
Which options is false for built-in-variables:
Values can be defined for built-in variables in a workflow or session parameter file.
The Integration Service looks for the start value of a variable in the following order:
- Value in parameter file
- Value saved in the repository (if the variable is persistent)
- User-specified default value
- Datatype default value
which among the following is not a variable function?
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
What is difference between $ and $$ parameters/variables?
$ are System defined and $$ are User defined variables
To assign a null value to $PMBadFileDir , set the parameter or variable value to
$PMBadFileDir=<NULL>
Which of the below statement is not true about Mapplet
COBOL Sources and XML Sources can be used in mapplet
Which of the below statement about reusable component is true?
We cannot revert back Reusable transformation to normal one
Which of the below object cannot be used in Mapplet.
- Expression Transformation
- Lookup Transformation
- Normalizer transformation
- Mapplet
3&4
A mapplet must contain at least one ______ with at least one connected port in the mapplet.
Ouput Transformation
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.
What is a mapplet?
A mapplet is a reusable object that is created using mapplet designer.
Which statement is true of Worklets but NOT of Mapplets?
They can be nested
Which is not a valid option of UPDATE STRATEGY transformation
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
which of the transformation cannot be created as Reusable transformation?
Source qualifier
_________ definitions are not allowed in mapplet
Target
What happens if the Lookup table is larger than the Lookup Cache?
the Power Center Server stores the overflow values in the cache files
Which components are required to run a debug session?
The Designer 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
What is a conformed dimension?
Dimesion which is connected to more than one fact.
Which is not a Valid SCD type 2?
Version
Which SCD type stored Partial history?
SCD Type 3
Which type of SCD can store the complete history
SCD Type 2
Which is not a valid options in Target Load type Property?
NORMAL
The tasks that can be performed using Workflow Manager
Create and delete workflows, configure connections, create tasks
Create and delete workflows, configure connections, create tasks
Workflows must be within Tasks to be executed
Which of the following is a type of workflow task?
Event Raise
How to run a workflow without using GUI i.e, Workflow Manager, Workflow Monitor?
Using pmcmd command
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
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 using session recovery option
Difference between stop and abort
Stop – Stops the Session
Abort – Kills the session.
Which command line program should you use to start a workflow from a batch file?
pmcmd
Which of the following objects can be scheduled?
Workflows
which command is used to execute workflow tasks from the command line
PMCMD
A scheduling tool from BMC software
and) CONTROL M
How to determine whether the incoming record already exists in the target table?
Using Lookup Transformation
A pipeline consists of a ______________
source qualifier ,all the transformations and targets that receive data from that source qualifier