Informatica | Beginner Mock Test
1
Which of the following services will not be created by admin
a. Application Service
b. core
c. Repository Service
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : core [/bg_collapse]
2
Which of the following can be the target instance?
a. Relational
b. Relational, FlatFile and XML
c. OLL
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Relational, FlatFile and XML [/bg_collapse]
3
Which service reads mapping and session from the repository
a. Integration service
b. Connection service
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Integration service [/bg_collapse]
4
In Workflow monitor, what are all the components you can view?
a. Session, Command, Workflow
b. Session, Command, Workflow, repository
c. Session, Command, Workflow, repository, Folders
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Session, Command, Workflow [/bg_collapse]
5
Flatfile cannot be used for
a. Source
b. Lookup
c. Aggregator
d. Target
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Aggregator [/bg_collapse]
6
Gantt Chart –
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Chronologic detail of logs [/bg_collapse]
7
Logs can be viewed in
a. Text File
b. XML
c. Binary Code
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : XML [/bg_collapse]
8
Transformation that does not store cache file
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Router [/bg_collapse]
9
___________ connects Integration service to metadata
a. Repository Service
b. Repository Manager
c. Metadata Manager
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Repository Service [/bg_collapse]
10
When a source is imported?
a. Data type/ Column name
b. Data type/ Column name/Key Constraint
c. Stored Procedure
d. Triggers
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Data type/ Column name/Key Constraint [/bg_collapse]
11
Chronological details of workflow
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Gantt chart [/bg_collapse]
12
Which transformation does not have variable port?
a. Expression
b. Rank
c. Filter
d. Aggregator
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Filter [/bg_collapse]
13
-sv means
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Integration service name [/bg_collapse]
14
Power Center domain means?
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A domain is the primary unit for management and administration of services in PowerCenter. [/bg_collapse]
15
________ is a set of instruction that extract, transforms and load data?
a. command
b. Session
c. Workflow
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Workflow [/bg_collapse]
16
If the session fails, how will u identify the log?
a. log status
b. Error log code
c. log text files
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : All of the above [/bg_collapse]
17
Reusable components in mapping
a. Workflow
b. Mapplet
c. Transformation
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Mapplet [/bg_collapse]
18
Set of instruction which transforms data from source to target
19
Flat Files – Fixed/Delimited
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Delimited [/bg_collapse]
20
Which is not true about Sorter
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : It is passive [/bg_collapse]
21
User defined events are possible?
a. Yes, with combination of event wait and event raise
b. Yes. On;y with workflow only
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Yes, with combination of event wait and event raise [/bg_collapse]
22
Source can be created
a. table
b. table,view
c. table,view,synonmyms
d. table,view, stored procedures
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : table,view,synonmyms [/bg_collapse]
24
How to run the workflow using command?
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : PMCMD [/bg_collapse]
25
GET_DATE_PART(Column 1,’HH’.If the column 1 is null, What is the result?
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : only HH [/bg_collapse]
26
Once the source is dragged into mapping, it needs to be connected to?
a. SQ
b. Sorter
c. Agg
d. EXP
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : SQ [/bg_collapse]
27
Workflow log contains?
a. Status of Session, Tasks and Worklet
b. Error occured and general information
c. None of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer :
28
What is active transformation?
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Changes in the number of rows [/bg_collapse]
29
If the group by is not given in the Aggregator transformation, it will return
a. All the rows
b. One row
c. Error
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : One row [/bg_collapse]
30
Shortcut can be used in which of the componets
a. Source definition
b. Reusable components
c. Mapplet
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Source definition (All of the above – Doubt. [/bg_collapse]
31
Short cut can be used from
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Shared Folder [/bg_collapse]
32
You have to run a task but two different session. What is the best way?
a. Post SQL
b. Command task
c. Combination of events
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Command Task [/bg_collapse]
33
Tracing Levels
a. Normal
b. Verbose
c. None
d. Both a and b
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Both a and b[/bg_collapse]
34
To see error logs to resolve it
a. use log events
b. use Text Code
c. use Prefix
d. All of the above
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Use log events [/bg_collapse]
35
Session invalid?
a. Adding table in the source databse
b. Adding Update/Joiner transformation
c. Deleting row from target table
d. Creating Index on source tables
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Adding Update/Joiner transformation [/bg_collapse]
36
Which provides row by row details about insert/update/delete?
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Update Strategy [/bg_collapse]
37
Control M – from BNC s/w
38
Target which cannot be used?
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : COBOL [/bg_collapse]
39
Workflow monitor
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : Logs [/bg_collapse]
Types of Tasks
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Tasks” collapse_text=”Hide Tasks” ]
| Tasks | Description |
| Assignment | Used to assign a value to a workflow variable |
| Command | Used to run a shell command during the workflow |
| Control | Used to stop or abort the workflow |
| Decision | Tells a condition to evaluate |
| Used to send email during the workflow | |
| Event-Raise | Notifies the Event-Wait task that an event has occurred |
| Event-Wait | It waits for the event to completed in order to start the next task |
| Session | Used to run the mapping created in Designer buy linking to session |
| Timer | It waits for a already timed event to start |
[/bg_collapse]
