Intelligent Informatica Test (powercenter) Assessment Test

10 Questions

Settings
Please wait...
Intelligent Informatica Test (powercenter) Assessment Test

PowerCenter is a product of Informatica widely used in building enterprise data warehouses, as an efficient ETL tool. Take this quiz to assess your knowledge of PowerCenter.


Questions and Answers
  • 1. 
    Which of these is not an ETL tool?
    • A. 

      Oracle Warehouse Builder

    • B. 

      Informatica PowerCenter

    • C. 

      IBM Infosphere Information Server

    • D. 

      SQL Server Interpretation Services

  • 2. 
    PowerCenter is the _________-driven data integration platform.
    • A. 

      Prodata

    • B. 

      Metadata

    • C. 

      Microdata

    • D. 

      Data

  • 3. 
    What is the full meaning of ETL?
    • A. 

      Elect, Translate and Lead

    • B. 

      Extract, Transform and Load

    • C. 

      Extract, Translate and Load

    • D. 

      Elect, Transform and Load

  • 4. 
    Workflows in Informatica PowerCenter are created by...
    • A. 

      Workflow creator

    • B. 

      Workflow monitor

    • C. 

      Workflow manager

    • D. 

      Workflow administrator

  • 5. 
    Which of these terms can be described as the pictorial representation of data flow from source to target?
    • A. 

      Data monitor

    • B. 

      Workflow

    • C. 

      Mapping

    • D. 

      Path

  • 6. 
    All of these are examples of transformation in Informatica except...
    • A. 

      Joining

    • B. 

      Filtering

    • C. 

      Aggregation

    • D. 

      Collection

  • 7. 
    In Informatica PowerCenter, the ETL layer comprises of...
    • A. 

      Server and repository

    • B. 

      Server and repository server

    • C. 

      Client tools and server

    • D. 

      Client tools and repository

  • 8. 
    Informatica is primarily focused on solving problems using...
    • A. 

      Data extraction

    • B. 

      Data integration

    • C. 

      Data transmission

    • D. 

      Data loading

  • 9. 
    Which of these tasks is not performed by ETL?
    • A. 

      Extraction of data from sources

    • B. 

      Updating of warehouses

    • C. 

      Creation of data

    • D. 

      Summarizing data

  • 10. 
    How does PowerCenter read data in a table?
    • A. 

      Column by column

    • B. 

      Row by row

    • C. 

      Column by row

    • D. 

      Row by Column