WorksheetsInformatica Quiz
Total questions: 48
Worksheet time: 48mins
User defined join is possible in source qualifier when
sources are flat files
sources are relational database
All of the above.
None of the above
Target override can be used to override the update strategy
true
false
SQL override cannot be overwritten in the session
true
false
Can we compare two repository objects of the same type to identify differences between the objects?
yes
no
not possible
none of the above
Only first error information can be viewed from session run properties.
true
false
In a workflow where is the information service assigned?
command task
session
worklet
workflow
Repository services can be shutdown or startup repository manager console
true
false
Informatica requires at least following databases up and running to start up the informatica services.
Domain database
Repository database
Source database
All of the above
Aggregator transformation can be used to
Filter the records with multiple conditions
Perform aggregate calculations
Define a custom query that replaces the default query.
None of the above
Which type of architecture followed in informatica 8.x onwards?
Server-client
Service oriented architecture
2 tier architecture
None of the above
What is the sequence of bringing up various services in informatica?
Integration service-repository service- other application service
SAP-BW service-repository service-integration service-other application service
All of the above.
None of the above
Which of the following transformation can be used to sort the data in relational sources?
source qualifier
sorter
All of the above.
None of the above
Service Manager runs in UNIX as
Service
Daemon
none
Any of the above
Who manages all operations of domain
Service manager
Application service
Load manager
DTM
Session logs can be saved for every execution date and time.
true
false
Command can be written in command task as well in the session
true
false
Workflow can't be schedule with external scheduler?
true
false
Which of the following types of join supported by joiner transformation?
Normal
Master outer and detail outer
Full outer
All of the above
Name and number of ports in the source and source qualifier must be same and identical to make the mapping valid.
true
false
Store procedure transformation is
Active
passive
both
none
Workflow along with all it sessions and mappings can be copied from one repository to another from workflow manager.
true
false
All the file names and directories can be parameterized as session parameter.
true
false
Searching for repository objects using the following methods can be done using
keyword search
search text
All of the above.
None of the above
An unconnected stored procedure transformation is not directly connected to the flow of data through the mapping
true
false
A reusable transformation cannot be converted to Non reusable.
true
false
Filter transformation is responsible for
Filtering the data from flat files
Filtering the data from relational sources
Filtering data input from previous transformation
All of the above.
Target load plan does not determine the execution order of different pipeline mapping with mapping.
true
false
Which of the following are done by DTM process?
creates threads to initialize the session, read, write and transform data
handle pre-session and post-session operations
starts the session
sends post session email when the session completes
Which all value present in 'Treat source rows as' property?
insert
update
delete
data driven
Union transformation can
remove duplicate rows
cannot remove duplicate rows
All of the above.
None of the above
Run a stored procedure once during a mapping, such as pre- or post-session,which mode can be used
Connected
Not-connected
all the above
none of the above
Which of the below conditions can be used in joiner transformation
Equality(=)
Greater then equals to(>=)
Less than equals to(<=)
All of the above
Informatica keeps only recent session log and hence session logs of older execution can never be retrieved.
true
false
Folder comparison is possible in repository manager between
two folders in the same repository
two folders in the different repositories
All of the above.
None of the above
Mapplet contains
A set of transformations
A set of mappings
A set of target definitions
None of the above
Which all properties need to fill up when error log type is 'relational database'?
Error log file directory
Data column delimiter
Error log file Nam
All of the above
If you want to run a stored procedure before or after a session, which mode can be used
Connected
Not-connected
all the above
none of the above
Repository manager can import and export
Multiple objects from one folder
Single object from one folder
All of the above.
None of the above
Session can be restarted from workflow monitor
true
false
What are the different types of error log is present in session properties?
Relation database
Flat file
Both A and B
None of the above.
Default group of router transformation does the following
Route all incoming records
Routes none of the incoming records
Routes those records which satisfy the condition of other groups
None of the above.
Normalizer transformation is used for
Source qualifier for COBOL sources
Used in the pipeline to normalize data from relational or flat file sources
Receive a row that contains multiple-occuring columns and returns a row for each instance of the multiple-occuring data
All of the above
Workflow can be scheduled to run continuously
true
false
Which of the following statements are correct for source qualifier transformation?
Defines a custom query that replaces the default query
Specifies the condition used to join data from multiple sources represented in the same source qualifier transformation
indicates the number of columns used when sorting rows queried from relational sources
All of the above
Which of the following information are incorrect according to repository manager task?
Truncate session and workflow log entries
Compare repository objects.
Exchange metadata with other business intelligence tools.
None of these.
Session can execute from the task developer panel
true
false
We can filter the rows using source qualifier when
sources are relational databases
sources are flat files
All of the above.
None of the above
Which of the following scenarios is the description for Router Transformation
We can use multiple filter conditions to route the records to different target
It can be used to catch rejected rows
All of the above.
None of the above
