Intelligent Informatica Siperian Assessment Test

10 Questions

Settings
Please wait...
Intelligent Informatica Siperian Assessment Test

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