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

Answer : core 

2
Which of the following can be the target instance?
a. Relational
b. Relational, FlatFile and XML
c. OLL
Answer : Relational, FlatFile and XML 

3
Which service reads mapping and session from the repository
a. Integration service
b. Connection service
Answer : Integration service 

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
Answer : Session, Command, Workflow 

5
Flatfile cannot be used for
a. Source
b. Lookup
c. Aggregator
d. Target
Answer : Aggregator 

6
Gantt Chart –
Answer : Chronologic detail of logs 

7
Logs can be viewed in
a. Text File
b. XML
c. Binary Code
d. All of the above
Answer : XML 

8
Transformation that does not store cache file
Answer : Router 

9
___________ connects Integration service to metadata
a. Repository Service
b. Repository Manager
c. Metadata Manager
Answer : Repository Service 

10
When a source is imported?
a. Data type/ Column name
b. Data type/ Column name/Key Constraint
c. Stored Procedure
d. Triggers
Answer : Data type/ Column name/Key Constraint 

11
Chronological details of workflow
Answer : Gantt chart 

12
Which transformation does not have variable port?
a. Expression
b. Rank
c. Filter
d. Aggregator
Answer : Filter 

13
-sv means
Answer : Integration service name 

14
Power Center domain means?
Answer : A domain is the primary unit for management and administration of services in PowerCenter

15
________ is a set of instruction that extract, transforms and load data?
a. command
b. Session
c. Workflow
Answer : Workflow 

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
Answer : All of the above 

17
Reusable components in mapping
a. Workflow
b. Mapplet
c. Transformation
Answer : Mapplet 

18
Set of instruction which transforms data from source to target
19
Flat Files – Fixed/Delimited
Answer : Delimited 

20
Which is not true about Sorter
Answer : It is passive 

21
User defined events are possible?
a. Yes, with combination of event wait and event raise
b. Yes. On;y with workflow only
Answer : Yes, with combination of event wait and event raise 

22
Source can be created
a. table
b. table,view
c. table,view,synonmyms
d. table,view, stored procedures
Answer : table,view,synonmyms 

24
How to run the workflow using command?
Answer : PMCMD 

25
GET_DATE_PART(Column 1,’HH’.If the column 1 is null, What is the result?
Answer : only HH 

26
Once the source is dragged into mapping, it needs to be connected to?
a. SQ
b. Sorter
c. Agg
d. EXP
Answer : SQ 

27
Workflow log contains?
a. Status of Session, Tasks and Worklet
b. Error occured and general information
c. None of the above
Answer :
28
What is active transformation?
Answer : Changes in the number of rows 

29
If the group by is not given in the Aggregator transformation, it will return
a. All the rows
b. One row
c. Error
Answer : One row 

30
Shortcut can be used in which of the componets
a. Source definition
b. Reusable components
c. Mapplet
d. All of the above
Answer : Source definition (All of the above – Doubt. 

31
Short cut can be used from
Answer : Shared Folder 

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
Answer : Command Task 

33
Tracing Levels
a. Normal
b. Verbose
c. None
d. Both a and b
Answer : Both a and b

34
To see error logs to resolve it
a. use log events
b. use Text Code
c. use Prefix
d. All of the above
Answer : Use log events 

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
Answer : Adding Update/Joiner transformation 

36
Which provides row by row details about insert/update/delete?
Answer : Update Strategy 

37
Control M – from BNC s/w
38
Target which cannot be used?
Answer : COBOL 

39
Workflow monitor
Answer : Logs 

 

Types of 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
Email 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