This Informatica Certification Exams General Practice Test assesses knowledge in data warehousing and business intelligence. It covers key concepts such as organizational decision-making, data marts, operational data stores, and extraction processes.
True
False
Rate this question:
ODS
OLTP
OLAP
OLCP
DSS
Rate this question:
Dimension
Database
Datamart
Fact
Datawarehouse
Rate this question:
Fact tables
Dimension tables
Indexes
Views
Synonyms
Rate this question:
Loading
Transforming
Cleansing
Refreshing
Extraction
Rate this question:
Incremental Extraction
Full Extraction
Online Extraction
Offline Extraction
None
Rate this question:
ODS
OLTP
Staging
ODS&OLTP
None
Rate this question:
Full Load
Direct Load
Incremental Load
Option 1 & Option 3
All of the above
Rate this question:
Transformation
Extraction
Loading
All of the above
None
Rate this question:
8 Bit
16 Bit
32 Bit
64 Bit
128 Bit
Rate this question:
Depends upon the User
NO
YES
Only at some times
I don't know
Rate this question:
Depends upon the User
NO
I don't know
Only at some times
YES
Rate this question:
5
3
0
No client tools
I don't know
Rate this question:
Designer
Workflow Manager
2&3
Repository Manager
Repository administration console
Rate this question:
Workflow Monitor
Mapping Designer
Workflow Manager
Repository Manager
Worklet Designer
Rate this question:
Designer
Workflow Manager
Repository Manager
2&3
None
Rate this question:
Source qualifier
Transformation Developer
Workflow Designer
Mapping Designer
Warehouse Designer
Rate this question:
Yes
No
Sometimes
May be possible
None
Rate this question:
Workflow Monitor
Mapping Designer
Workflow Manager
Repository Manager
Worklet Designer
Rate this question:
Depends upon the User
FALSE
TRUE
Only at some times
I don't know
Rate this question:
Synonyms
Dimension tables
Indexes
Database tables
I don't know
Rate this question:
Through native drivers
Third party softwares
LAN Drivers
Logical Paths
I don't know
Rate this question:
Depends upon the User
FALSE
TRUE
Only at some times
I don't know
Rate this question:
Text file
Zip File
XML File
Binary File
I don't know
Rate this question:
Through repository agent process
Through native drivers
Through LAN Drivers
Through PSTN Lines
I don't know
Rate this question:
Your local machine's IP
Your Project Name
Host name and Port no
Your Mobile no
I don't know
Rate this question:
60 Secs
30 Secs
15 Secs
120 Secs
I don't know
Rate this question:
Designer
DLM Process
DTM Process
DLF Process
I don't know
Rate this question:
Workflow Manager
Load Manager
Workflow Monitor
Designer
I don't know
Rate this question:
Informatica Server
Workflow Server
Informatica repository Server
Option 1 & Option 3
Option 1 & Option 2
Rate this question:
Yes
No
May be true
Sometimes
Rate this question:
Repository Manager
Designer
Workflow Manager
Workflow Monitor
Repository Server
Rate this question:
Depends upon the User
FALSE
TRUE
Only at some times
I don't know
Rate this question:
1
3
5
7
9
Rate this question:
Administrator
Read
Write
Super User
Execute
Rate this question:
Read
Write
Execute
Super User
Administrator
Rate this question:
Create Shortcuts
Allow shortcut
Shortcuts
None
Option 1 & Option 2
Rate this question:
Designer
PowerCenter Server
Workflow Manager
Workflow Monitor
Repository Manager
Rate this question:
5
4
3
2(interactive and commandline)
0
Rate this question:
PowerCenter Server
Repository Manager
Workflow Manager
Workflow Monitor
Designer
Rate this question:
1(not available--connection failed)
0(successful)
3(error)
5(internal pmcmd error)
7(invalid user)
Rate this question:
Setfolder
Usefolder
Setnowait
Setwait
Showsettings
Rate this question:
Interactive mode
Commandline mode
User Mode
Server mode
Wait Mode
Rate this question:
Interactive mode
Commandline mode
User Mode
Server mode
Wait Mode
Rate this question:
0
Zero Return Codes
2
Non Zero return Codes/7
1
Rate this question:
Interactive mode
Commandline mode
User Mode
Server mode
Wait Mode
Rate this question:
Output
Workspace
Navigation
Mapping desginer
None
Rate this question:
4
3
2
6
5
Rate this question:
Quiz Review Timeline (Updated): Nov 10, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.