Scribd Logo
Upload

Welcome to Scribd!

  • 6K views

    Informatica MCQ

    Uploaded by

    Payal das
    This document provides a 20 question multiple choice quiz about Informatica to test knowledge of basic concepts. The questions cover topics like what ETL stands for, common transformations used in mappings, components of the Informatica architecture like repositories and services, and features of the product like writing objects in XML format. Correct answers are available by clicking a link to view the answer. The document encourages reading additional Informatica interview questions as well.

    Copyright:

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

    Informatica MCQ

    Uploaded by

    Payal das
    6K views5 pages
    This document provides a 20 question multiple choice quiz about Informatica to test knowledge of basic concepts. The questions cover topics like what ETL stands for, common transformations used in mappings, components of the Informatica architecture like repositories and services, and features of the product like writing objects in XML format. Correct answers are available by clicking a link to view the answer. The document encourages reading additional Informatica interview questions as well.

    Original Title

    informatica-mcq

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a 20 question multiple choice quiz about Informatica to test knowledge of basic concepts. The questions cover topics like what ETL stands for, common transformations used in mappings, components of the Informatica architecture like repositories and services, and features of the product like writing objects in XML format. Correct answers are available by clicking a link to view the answer. The document encourages reading additional Informatica interview questions as well.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    6K views5 pages

    Informatica MCQ

    Uploaded by

    Payal das
    This document provides a 20 question multiple choice quiz about Informatica to test knowledge of basic concepts. The questions cover topics like what ETL stands for, common transformations used in mappings, components of the Informatica architecture like repositories and services, and features of the product like writing objects in XML format. Correct answers are available by clicking a link to view the answer. The document encourages reading additional Informatica interview questions as well.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 5

    By OnlineInterviewQuestions.

    com
    Informatica MCQ Quiz

    Take Informatica Quiz To test your Knowledge


    Below are few Informatica MCQ test that checks your basic knowledge of Informatica. This Informatica Test
    contains around 20 questions of multiple choice with 4 options. You have to select the right answer to a
    question. You can see the correct answer by clicking view answer link.

    Also, Read Best Informatica interview questions.

    Q1. What Is Informatica.

    A. Reporting
    B. Modeling
    C. ETL
    D. None

    Q2. Which is the reusable component in Informatica?

    A. Workflow
    B. Mapplet
    C. Session
    D. Mapping

    Q3. ETL Stands for -

    A. Extraction,transformation and loading


    B. Extract transactions and load
    C. Enable transactions and load
    D. All of the mentioned

    Q4. Which one is not correct about filter transformation?

    A. Act like 'Case' in pl/sql


    B. Act as a 'where' condition
    C. Can't passes multiple conditions
    D. None of the above

    Q5. Which of the following server governs the implementation of various processes among
    the factors of server’s database repository.

    A. Temp server
    B. Repository server
    C. Domain server
    D. Powerhouse server

    Q6. Which of the following transformation is used to combine data from different
    sources?

    A. Lookup transformation
    B. Joiner transformation
    C. Union Transformation
    D. Expression transformation

    Q7. What is the full form of OLAP?

    A. On-Line Analytical Processing


    B. On-Line Analysis Processing
    C. On-Line Access Processing
    D. On-Line Application processing

    Q8. Which of the following transformation is used to handle cobol sources?

    A. Filter Transformation
    B. Source Qualifier
    C. Normalizer Transformation
    D. Expression Transformation

    Q9. Which of the following window in desginer is used to access the repositories?
    A. Navigation
    B. Workspace
    C. Mapping desginer
    D. None of the above

    Q10. Which of the following option is need to be checked for creating shortcuts for
    folders?

    A. Shortcuts
    B. Create Shortcuts
    C. Allow shortcut
    D. None of the above

    Q11. Which of the following session property enabled when update strategy is used in a
    mapping?

    A. DD_UPDATE
    B. DD_INSERT
    C. Data Driven
    D. DD_REJECT

    Q12. Which of the following tool is used for users, user groups and priviledges?

    A. Repository Manager
    B. Workflow Manager
    C. Designer
    D. None of the above

    Q13. The repository server create and update the repository tables through -

    A. Native drivers
    B. LAN Drivers
    C. PSTN Lines
    D. Repository agent process

    Q14. Which of the following transformation is used to convert the rows in to columns?
    A. Filter Transformation
    B. Source Qualifier
    C. Normalizer Transformation
    D. Router Transformation

    Q15. Which of the following Transformation is used to load the rejected records?

    A. Source Qualifier
    B. Router Transformation
    C. Filter Transformation
    D. None of the above

    Q16. Which of the following types of sources are available in informatica?

    A. Flatfiles
    B. Cobol and XML sources
    C. Homogeneous & Heterogeneous
    D. All of the above

    Q17. Which of the following component of informatica is used to see the performance of
    the workflow while running?

    A. Mapping Designer
    B. Workflow Monitor
    C. Worklet Designer
    D. Workflow Manager

    Q18. Can INFORMATICA objects be written in XML format?

    A. Yes
    B. No

    Q19. What is the different components of PowerCenter?


    A. PowerCenter Clients
    B. PowerCenter Service
    C. Repository Service
    D. All of the above

    Q20. What are the two types of Repositories in INFORMATICA?

    A. Global Repositories
    B. Local Repositories
    C. National Repositories
    D. Both A & B

    Please Visit OnlineInterviewquestions.com to download more pdfs

    You might also like