Hello friends if you are looking for Informatica L2 Assessment Question Answers | Informatica L2 MySkillz Wipro Questions with Answers | Informatica L2 TrendNXT MCQ With Answers | Informatica L2 Objective Type Questions with Answers then here you will get Answers for it.
How many return ports are allowed in unconnected lookup transformation ?
A) 2
B) 1
C) 3
D) Any number
Ans: b
which reference is used to call an unconnected lookup transformation?
A) :LKP
B) :LPK
C) LKP
D) no reference is required
Ans: a
the transformation that control how the rows are flagged for Insert, Update, Reject or Delete in a Mapping
A) Router
B) Lookup
C) Update Strategy
D) Filter
Ans: c
The kinds of information that are stored in the repository are
A) Repository configuration details
B) Mappings
C) Workflows
D) All of the above
Ans: d
Which PowerCenter applications are used for creating and administrating folders?
A) Administration Console and Workflow manager
B) Repository Manager and Administration Console
C) Workflow Manager and Workflow Monitor
D) Designer and Workflow Manager.
Ans: b
The dependency window can display following type of dependency
A) source target dependencies
B) Mapping dependencies
C) shortcut dependencies
D) All of the above
Ans: d
Which types of objects can be visible in the Repository Manager Navigator window?
A) Mappings, repository users, and source and target definitions
B) Repository users, folders and sub folders ,and source and target definitions
C) Business components,Mappings,reusable transformations
D) Mappings and Mapplets,Integration Services,and folders and subfolders
Ans: c
One of the following partition types available to Informatica ensures that data is evenly distributed among all partitions
A) Hash partitioning
B) n:n Master/Detail partitioning
C) Keyrange partitioning
D) Round-robin partitioning
Ans: d
If you have created a session using source-based commit, which partition type do you use on the Relational and Flat File targets?
A) Round-Robin Partitioning
B) Pass-Through
C) Data-Driven
D) Hash User-Keys
Ans: b
A partition executes in a _________
A) single reader, transformation, or writer thread
B) single reader, or writer thread
C) multiple reader, transformation, or writer thread
D) single reader, multiple transformation, or multiple writer thread
Ans: a
Which partition type need to be used if the target tables are partitioned on key range
A) round robin
B) Hash auto keys
C) Key Range
D) database
Ans: c
Partitioning option helps configure which of the following?
A) Multiple partitions for a single pipeline stage, Partitioning information that controls the number of threads (reader, transformation, and writer)
B) Number of source and target connections to use
C) How the Integration Service reads data from the source, distributes rows of data to each transformation
D) All of the above
Ans: d
You cannot create partition point for which of the following transformations
A) Source Qualifier
B) Joiner
C) Sequence Generator
D) Both A & C
Ans: c
Which of the following is true in case of a Round Robin partitioning type
A) The integration service passes all rows at one partition point to the next partition point without redistributing them
B) The integration service passes the data to each partition depending on the ranges you specify for each port
C) The integration service distributes data evenly among all partitions
D) The integration service distributes data to the partitions by group
Ans: c
Which is not a type of partition?
A) Round robin
B) database
C) pass through
D) key hash
Ans: d
Which of following changes to mappings can cause partitioned session failure?
A) Delete a transformation that was a partition point
B) Add a transformation that is a default partition point
C) Move a transformation that is a partition point to a different pipeline
D) All of the above
Ans: d
Which of the below statements is true?
A) You can change the parameter file when the workflow is running
B) You cannot change the parameter file when the workflow is running
C) once a parameter file is created, it can never be changed.
D) parameter files can be created dynamically
Ans: b
What is the difference between a mapping parameter and a mapping variable?
A) A parameter value can change throughout a Session Task run, and a mapping variable value remains constant.
B) A parameter value remains constant throughout a Session Task run, and a mapping variable value can change.
C) A parameter value must be read from a flat file, and a mapping variable value must be recalculated with an expression for each row.
D) A mapping variable value must be read from a flat file, and a parameter value must be recalculated with an expression for each row.
Ans: b
Parameters are created in which tool?
A) Repository manager
B) Designer
C) workflow monitor
D) Admin console
Ans: b
What is the difference between the system variables $$$SessionStartTime and SESSSTARTTIME?
A) $$$SessionStartTime returns the session start time as a string , and SESSSTARTTIME returns the session start time as date/time
B) $$$SessionStartTime returns the session start time as integer , and SESSSTARTTIME returns the session start time as date/time
C) $$$SessionStartTime returns the session start time as a string , and SESSSTARTTIME returns the session start time as integer
D) There is no difference in practice.Either can be used to return the session start time.
Ans: a
Which among these is not a task specific predefined workflow variable?
A) Condition
B) EndTime
C) ErrorCode
D) ErrorName
Ans: d
Which is not true about built in functions $$$SessStartTime and SESSSTARTTIME ?
A) $$$SessStartTime cannot be use in Mapping or mapplet filter condition.
B) SESSSTARTTIME can be used in expressions.
C) $$$SessStartTime can be used in sql overrides.
D) NONE
Ans: a
Which options is false for built-in-variables:
A) Built-in variables return either run-time or system information
B) Values can be defined for built-in variables in a workflow or session parameter file.
C) The integration service sets the values for built in variables.
D) Built-in variables can be used in expressions in Designer.
Ans: b
The Integration Service looks for the start value of a variable in the following order:
A) 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
B) 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
C) 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
D) 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
Ans: a
which among the following is not a variable function?
A) SetMaXVariable
B) SetMinVariable
C) SetCountVariable
D) SetAvgVariable
Ans: d
If we enter a space between the parameter name and the equals sign, the Integration Service interprets the space as
A) part of the parameter name
B) part of the parameter value
C) Ignores it
D) Throws an error
Ans: a
What is difference between $ and $$ parameters/variables?
A) $ are User defined and $$ are System defined variables
B) $ are System defined and $$ are User defined variables
C) $ are Session Level defined and $$ are Mapping Level defined variables
D) $ are Mapping Level defined and $$ are Session Level defined variables
Ans: b
To assign a null value to $PMBadFileDir , set the parameter or variable value to
A) $PMBadFileDir=NULL
B) $ PMBadFileDir=’\0’
C) $PMBadFileDir=<null>
D) None of the Above
Ans: c
Which of the below statement is not true about Mapplet
A) Mapplets and mapplet ports display differently in the Mapplet Designer and the Mapping Designer
B) If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation
C) A mapplet can be active or passive depending on the transformations in the mapplet
D) COBOL Sources and XML Sources can be used in mapplet
Ans: d
Which of the below statement about reusable component is true?
A) We can revert back Reusable transformation to normal one
B) We cannot revert back Reusable transformation to normal one
C) Reusable components are only created in the mapping designer tool
D) once a reusable component is created, we need to use only that in all the mappings
Ans: b
Which of the below object cannot be used in Mapplet.
1. Expression Transformation
2. Lookup Transformation
3. Normalizer transformation
4. Mapplet
A) 1&2
B) 2&3
C) 3&4
D) 4
Ans: c
A mapplet must contain at least one _____ with at least one connected port in the mapplet.
A) Input Transformation
B) Ouput Transformation
C) Sequence Generator
D) None
Ans: b
Which of the following actions when performed on a mapplet can cause an existing mappings to become invalid?
A) Do not delete connected ports in an Input or Output transformation
B) Do not change the data type, precision, or scale of connected ports in an Input or Output transformation
C) Do not change a passive mapplet to an active mapplet or an active mapplet to a passive mapplet.
D) All of the above
Ans: d
What is a mapplet?
A) A mapplet used to run a batch of mappings
B) A mapplet is a reusable object that is created using mapplet designer.
C) A mapplet is a database object referred in a mapping
D) None of the above
Ans: b
Which statement is true of Worklets but NOT of Mapplets?
A) They are reusable by nature
B) They encapsulate part of the functionality of a Workflow/Mapping
C) They have their own Designer tool
D) They can be nested
Ans: d
Which is not a valid option of UPDATE STRATEGY transformation
A) DD_DELETE
B) DD_INSERT
C) DD_UPDATE
D) DD_TRUNCATE
Ans: d
If you delete ports in the mapplet when the mapplet is used in a mapping, which of the following is True?
A) It invalidates the mapping
B) It does not invalidate the mapping
C) It will invalidate the mapplet
D) None of the above
Ans: a
which of the transformation cannot be created as Reusable transformation?
A) sequence genertor
B) Source qualifier
C) sorter
D) expression
Ans: b
_____________ definitions are not allowed in mapplet
A) Target
B) source
C) trasnformation
D) None of the Above
Ans: a
What happens if the Lookup table is larger than the Lookup Cache?
A) the Power Center Server stores the overflow values in the cache files
B) The workflow execution will fail
C) The workflow will execute with error
D) the system will hang
Ans: a
Which components are required to run a debug session?
A) The Designer
B) The Designer and the Workflow Manager
C) The Designer and a running Informatica server
D) The Designer, the Workflow Manager, and a running Informatica server
Ans: c
What type of debugger sessions can be configured?
B) Use an existing reusable session
C) Create a debug session instance
D) All of the above
Ans: d