Intelligent Informatica Siperian Assessment Test
10 Questions
| Total Attempts: 132
In the early 2010s, Informatica acquired a software called Siperian, which is an MDM (mobile driven management) application integrated, driven by a model, and provides solutions for small to big businesses.
Questions and Answers
- 1.
Which of these is a tool which implement MDM?- A.
Java
- B.
Scala
- C.
Groovy
- D.
Informatica
- 2.
What happens to duplicate records in Informatica project plan?
- A.
It'll be deleted
- B.
It'll be merged with original
- C.
It'll be changed
- D.
It'll be cleaned
- 3.
In how many ways can you access Informatica console?
- A.
1
- B.
2
- C.
3
- D.
4
- 4.
At what stage is a data warehouse updated?
- A.
Offline operational
- B.
Real time
- C.
Offline
- D.
Integrated
- 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.
How many ways can you load a dimension table?
- A.
1
- B.
2
- C.
3
- D.
4
- 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.
Open
- B.
Close
- C.
Dynamic
- D.
Static
- 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