Intelligent Informatica Assessment Test
10 Questions
| Total Attempts: 159
Founded in 1993, Informatica is a software company that deals with enterprise cloud data integration and management. Take this quiz to find out more.
Questions and Answers
- 1.MDM includes the _______ that reliably characterize and deal with the critical data of an organization to provide a single point of reference. Which one of the following is odd?
- A.
Processes
- B.
Policies
- C.
Formatting
- D.
Tools
- E.
Standards
- 2.What happens to duplicated records in Informatica Project Plan?
- A.
It'll be deleted
- B.
It'll be merged with original
- C.
It'll be cleaned
- D.
It'll be changed
- 3.In how many ways can you access the Informatica Console?
- A.
7
- B.
3
- C.
1
- D.
2
- 4.At what stage is a data warehouse updated?
- A.
Offline operational
- B.
Real time
- C.
Integrated
- D.
Offline
- 5.Which of these represents the flow of data between targets and sources?
- A.
Map
- B.
Transformation
- C.
Transaction
- D.
Mining
- 6.What is the foreign key column in a dimension table?
- A.
Primary keys of entity tables
- B.
Surrogate keys
- C.
Primary keys of dimension tables
- D.
Mixed keys
- 7.In how many ways can you load a dimension table?
- A.
4
- B.
8
- C.
1
- D.
2
- 8.In direct dimension table, loading all the keys and constrains are _____ prior to loading the data.
- A.
Enabled
- B.
Cleaned
- C.
Disabled
- D.
Translated
- 9.A mapping variable is...
- A.
Static
- B.
Dynamic
- C.
Open
- D.
Close
- 10.What are the two types of data movement in Informatica?
- A.
Unicode Mode and ASCII Mode
- B.
OLAP and ASCII Mode
- C.
Unicode Mode and OLAP Mode
- D.
OLAP and Port
Back to top