Informatica | Beginner Question and Answers

Informatica | Beginner Mock Test

1
Which of the following services will not be created by admin
a. Application Service
b. core
c. Repository Service
Show Answer

2
Which of the following can be the target instance?
a. Relational
b. Relational, FlatFile and XML
c. OLL
Show Answer
3
Which service reads mapping and session from the repository
a. Integration service
b. Connection service
Show Answer
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
Show Answer
5
Flatfile cannot be used for
a. Source
b. Lookup
c. Aggregator
d. Target
Show Answer
6
Gantt Chart –
Show Answer
7
Logs can be viewed in
a. Text File
b. XML
c. Binary Code
d. All of the above
Show Answer
8
Transformation that does not store cache file
Show Answer
9
___________ connects Integration service to metadata
a. Repository Service
b. Repository Manager
c. Metadata Manager
Show Answer
10
When a source is imported?
a. Data type/ Column name
b. Data type/ Column name/Key Constraint
c. Stored Procedure
d. Triggers
Show Answer
11
Chronological details of workflow
Show Answer
12
Which transformation does not have variable port?
a. Expression
b. Rank
c. Filter
d. Aggregator
Show Answer
13
-sv means
Show Answer
14
Power Center domain means?
Show Answer
15
________ is a set of instruction that extract, transforms and load data?
a. command
b. Session
c. Workflow
Show Answer
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
Show Answer
17
Reusable components in mapping
a. Workflow
b. Mapplet
c. Transformation
Show Answer
18
Set of instruction which transforms data from source to target
19
Flat Files – Fixed/Delimited
Show Answer
20
Which is not true about Sorter
Show Answer
21
User defined events are possible?
a. Yes, with combination of event wait and event raise
b. Yes. On;y with workflow only
Show Answer
22
Source can be created
a. table
b. table,view
c. table,view,synonmyms
d. table,view, stored procedures
Show Answer
24
How to run the workflow using command?
Show Answer
25
GET_DATE_PART(Column 1,’HH’.If the column 1 is null, What is the result?
Show Answer
26
Once the source is dragged into mapping, it needs to be connected to?
a. SQ
b. Sorter
c. Agg
d. EXP
Show Answer
27
Workflow log contains?
a. Status of Session, Tasks and Worklet
b. Error occured and general information
c. None of the above
Show Answer
29
If the group by is not given in the Aggregator transformation, it will return
a. All the rows
b. One row
c. Error
Show Answer
30
Shortcut can be used in which of the componets
a. Source definition
b. Reusable components
c. Mapplet
d. All of the above
Show Answer
31
Short cut can be used from
Show Answer
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
Show Answer
33
Tracing Levels
a. Normal
b. Verbose
c. None
d. Both a and b
Show Answer
34
To see error logs to resolve it
a. use log events
b. use Text Code
c. use Prefix
d. All of the above
Show Answer
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
Show Answer
36
Which provides row by row details about insert/update/delete?
Show Answer
37
Control M – from BNC s/w
38
Target which cannot be used?
Show Answer
39
Workflow monitor
Show Answer
 

Types of Tasks

 
Show Tasks