Intelligent Informatica Test (Powercenter) Assessment Test

10 Questions | Total Attempts: 829

SettingsSettingsSettings
Intelligent Informatica Test (Powercenter) Assessment Test - Quiz

PowerCenter is an Informatica product widely used in building enterprise data warehouses as an efficient ETL tool. This "Intelligent Informatica Assessment Test" will check your knowledge regarding PowerCenter. Here, we will ask only ten questions related to PowerCenter. If you have ever used this tool, the quiz will not be that hard for you. Don't believe in us! Why don't you take this online quiz and see for yourself? We wish you the best of luck!


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

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.