Scribd Logo
Upload

Welcome to Scribd!

  • 107 views

    ETL Test

    Uploaded by

    Raghav Konidena
    This document contains a 20 question ETL assessment questionnaire. The questions cover topics like star schemas, snowflake schemas, ETL processes, data warehousing concepts, Informatica tools, and differences between OLTP and OLAP. The goal of the assessment is to test knowledge of key concepts and components related to extracting, transforming, and loading data in a data warehouse.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    ETL Test

    Uploaded by

    Raghav Konidena
    107 views4 pages
    This document contains a 20 question ETL assessment questionnaire. The questions cover topics like star schemas, snowflake schemas, ETL processes, data warehousing concepts, Informatica tools, and differences between OLTP and OLAP. The goal of the assessment is to test knowledge of key concepts and components related to extracting, transforming, and loading data in a data warehouse.

    Original Description:

    hi ia m

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a 20 question ETL assessment questionnaire. The questions cover topics like star schemas, snowflake schemas, ETL processes, data warehousing concepts, Informatica tools, and differences between OLTP and OLAP. The goal of the assessment is to test knowledge of key concepts and components related to extracting, transforming, and loading data in a data warehouse.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    107 views4 pages

    ETL Test

    Uploaded by

    Raghav Konidena
    This document contains a 20 question ETL assessment questionnaire. The questions cover topics like star schemas, snowflake schemas, ETL processes, data warehousing concepts, Informatica tools, and differences between OLTP and OLAP. The goal of the assessment is to test knowledge of key concepts and components related to extracting, transforming, and loading data in a data warehouse.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 4

    ETL Assessment Questionnaire

    1. A snowflake schema is which of the following types of tables?


    a. Fact
    b. Dimension
    c. Helper
    d. `All of the above

    2. A star schema has what type of relationship between a fact and dimension
    table?
    a. Many to Many
    b. One to one
    c. One to Many
    d. All of the above

    3. The role of the ETL process is to identify erroneous data and to fix them.
    a. True
    b. False

    4. Star schema is suited to online transaction processing, and


    therefore is generally used in operational systems.
    a. True
    b. False

    5. The center of Star schema consists of one.


    a. Fact Table
    b. Dimension Table
    c. Fact Table and Dimension Table
    d. Views
    6. Which one is not correct about filter transformation?
    a. Acts as Where condition
    b. Cannot pass multiple conditions
    c. Acts like Case statement
    d. If one record doesnot match the condition then data is blocked.

    7. How to select distinct records form Source Qualifier?


    a. Choose non duplicate option
    b. Choose Select distinct option
    c. Choose Select non duplicate

    8. Which process is used for online analytical processing?


    a. Data Mart
    b. Data base
    c. Data warehouse
    d. Data

    9. A lookup transformation is used to look up data in


    a. flat file
    b. Relational table
    c. view
    d. synonyms
    e. All of the above

    10. Informatica Is_________?


    a. ETL Tool
    b. Reporting Tool
    c. Modelling Tool
    d. Application Server
    11. Which of the following is not Data Warehousing feature?
    a. Subject-oriented
    b. time-variant
    c. integrated
    d. volatile collection

    12. The data is stored, retrieved & updated in ____________.


    a. OLAP
    b. OLTP
    c. SMTP
    d. FTP

    13. What does ETL stand for?


    a. Extract Transact Load
    b. Extract Transform Load
    c. Extract Transfer Load
    d. Extract Testify Load

    14. The center of Snowflake schema consists of one.


    a. Fact Table
    b. Dimension Table
    c. Fact Table and Dimension Table
    d. No of the above

    15. What is the difference between database and data warehouse?

    16. State 2 difference between OLTP and OLAP?


    17. All data in flat file is in this format.

    a. Sort
    b. ETL
    c. Format
    d. String

    18. A ______ is a numeric value that a business wishes to count or sum.

    a. Dimension
    b. Fact
    c. Index
    d. Table

    19. The data is extracted completely from the source system in


    ________ extraction mode.

    a. Full
    b. Incremental
    c. Both Full and Incremental
    d. None of the above

    20._____ is not a Informatica Client tools.

    a. Designer
    b. Workflow Monitor
    c. Workflow Manager
    d. Workflow Repository

    You might also like