Informatica 220

219 Questions | Total Attempts: 1875

SettingsSettingsSettings
Please wait...
Company Quizzes & Trivia

A quiz created by Swapnil and Ajay for practice of Informatica


Questions and Answers
  • 1. 
    Which one is not correct about filter transformation?
    • A. 

      Act as a 'where' condition

    • B. 

      Can't passes multiple conditions

    • C. 

      Act like 'Case' in pl/sql

    • D. 

      If one record does not match condition, the record is blocked

  • 2. 
    Can we calculate in aggregator ?
    • A. 

      No

    • B. 

      Yes

  • 3. 
    Which one is not a type of fact?
    • A. 

      Semi-additive

    • B. 

      Additive

    • C. 

      Confirm fact

    • D. 

      Not additive

  • 4. 
    Which one is not a type of dimension ?
    • A. 

      Confirmed dimension

    • B. 

      Rapidly changing dimension

    • C. 

      Junk dimension

    • D. 

      Degenerated dimension

  • 5. 
    Which of these not correct about Code Page?
    • A. 

      A code page contains encoding to specify characters in a set of one or more languages

    • B. 

      A code page contains decoding to specify characters in a set of one or more languages

    • C. 

      In this way application stores, receives, and sends character data.

    • D. 

      None of these

  • 6. 
    What is a mapplet?
    • A. 

      Combination of reusable transformation.

    • B. 

      Combination of reusable mapping

    • C. 

      Set of transformations and it allows us to reuse

    • D. 

      None of these

  • 7. 
    What does reusable transformation mean?
    • A. 

      It can be re-used across repositories

    • B. 

      I can only be used in mapplet.

    • C. 

      It can use in multiple mapping only once

    • D. 

      It can use in multiple mapping multiple times

  • 8. 
    Which one is not an option in update strategy?
    • A. 

      Dd_reject

    • B. 

      4

    • C. 

      2

    • D. 

      Dd_delete

  • 9. 
    Can we update records without using update strategy?
    • A. 

      Yes

    • B. 

      No

  • 10. 
    • A. 

      Choose 'non duplicate' option

    • B. 

      Choose 'select distinct' option

    • C. 

      Choose 'Select non duplicate'

  • 11. 
    What type of repository is no available in Informatica Repository Manager?
    • A. 

      Standalone Repository

    • B. 

      Local Repository

    • C. 

      User Defined

    • D. 

      Versioned Repository

    • E. 

      Manual Repository

  • 12. 
    Joiner does not support flat file.
    • A. 

      False

    • B. 

      True

  • 13. 
    How to execute PL/SQL script from Informatica mapping?
    • A. 

      Lookup

    • B. 

      Store Procedure

    • C. 

      Expression

    • D. 

      None of these

  • 14. 
    NetSal= bassic+hra. In which transformation we can achive this?
    • A. 

      Aggregator

    • B. 

      Lookup

    • C. 

      Filter

    • D. 

      Expression

  • 15. 
    Which one is not an active transformation?
    • A. 

      Sequence generator

    • B. 

      Normalizer

    • C. 

      Sql

    • D. 

      Store Procedure

  • 16. 
    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

  • 17. 
    Which value returned by NewLookupRow port says that Integration Service does not update or insert the row in the cache?
    • A. 

      3

    • B. 

      2

    • C. 

      1

    • D. 

      0

  • 18. 
    Which one needs a common key to join?
    • A. 

      Source qualifier

    • B. 

      Joiner

    • C. 

      Look up

  • 19. 
    Which one support heterogeneous join?
    • A. 

      Source qualifier

    • B. 

      Joiner

    • C. 

      Look up

  • 20. 
    What is the use of target loader?
    • A. 

      Target load order is first the data is load in dimension table and then fact table.

    • B. 

      Target load order is first the data is load in fact table and then dimensional table.

    • C. 

      Load the data from different target at same time.

  • 21. 
    Which one is not tracing level?
    • A. 

      Terse

    • B. 

      Verbose

    • C. 

      Initialization

    • D. 

      Verbose initialization

    • E. 

      Terse initialization

  • 22. 
    Which output file is not created during session running?
    • A. 

      Session log

    • B. 

      Workflow log

    • C. 

      Error log

    • D. 

      Bad files

    • E. 

      Cache files

  • 23. 
    Is Fact table is normalized?
    • A. 

      Yes

    • B. 

      No

  • 24. 
    Which value returned by NewLookupRow port says that Integration Service inserts the row into the cache?
    • A. 

      0

    • B. 

      1

    • C. 

      2

    • D. 

      3

  • 25. 
    Which transformation only works on relational source?
    • A. 

      Lookup

    • B. 

      Union

    • C. 

      Joiner

    • D. 

      Sql