Intelligent Informatica Assessment Test

10 Questions

Settings
Please wait...
Assessment Test Quizzes & Trivia

Informatica is a software that allows a developer understand the architecture of the system, development of new applications, designing of major components. The Intelligent Informatica Assessment Test is designed to check the practical skills of an Informatica developer.


Questions and Answers
  • 1. 
    Which of these lookup can use both the dynamic and static cache?
    • A. 

      Dynamic lookup

    • B. 

      Connected lookup

    • C. 

      Static lookup

    • D. 

      Unconnected lookup

  • 2. 
    What type of transformation does not change the number of rows passing through it?
    • A. 

      Active

    • B. 

      Passive

    • C. 

      Unchanged

    • D. 

      Connected

  • 3. 
    Which of these Informatica commands acts like WHEN statements in WHERE condition in SQL?
    • A. 

      Router

    • B. 

      Cache

    • C. 

      Sorter

    • D. 

      Filter

  • 4. 
    Static lookup is also known as___lookup?
    • A. 

      Write only

    • B. 

      Read only

    • C. 

      Read and write only

    • D. 

      Draw only

  • 5. 
    Which of these commands kill the DTM and terminate the session with a 60 seconds timeout?  
    • A. 

      STOP

    • B. 

      ABORT

    • C. 

      TIMEOUT

    • D. 

      ERROR

  • 6. 
    What happens to a mapping when the data types between Source and it's corresponding Source Qualifier is altered?
    • A. 

      Mapping path changes

    • B. 

      Mapping is displayed as invalid

    • C. 

      The mapping data is automatically altered

    • D. 

      Mapping moves a step up

  • 7. 
    What is the maximum number for sorted ports in Sybase source system?
    • A. 

      11

    • B. 

      10

    • C. 

      5

    • D. 

      16

  • 8. 
    Which of these transformation source is used to join data from the same source system?
    • A. 

      Passive

    • B. 

      Joiner

    • C. 

      Filter

    • D. 

      Sorter

  • 9. 
    All of these are types of joiner transformation except____
    • A. 

      Normal

    • B. 

      Outer

    • C. 

      Master outer

    • D. 

      Full outer

  • 10. 
    Which of these operator is available in joiner join condition?
    • A. 

      Addition

    • B. 

      Equality

    • C. 

      Subscription

    • D. 

      Inequality