Informatica: A Practice Test For Developers! Hardest Trivia Quiz

219 Questions | Total Attempts: 22

Settings
Please wait...
Informatica: A Practice Test For Developers! Hardest Trivia Quiz

Informatica: A Practice Test for Developers! This is the Hardest Trivia Quiz you will ever come across when it comes to software development and the Informatica Power Center which helps in data warehousing. Do you think you have adequate information to tackle it? How about you give it a shot an get to find out for sure? All the best!


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 an 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 an 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. 
    How to select distinct records to form Source Qualifier?
    • 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

  • 26. 
    Which are both connected and unconnected?
    • A. 

      External Store Procedure

    • B. 

      Stored Procedure

    • C. 

      Lookup

    • D. 

      Advanced External Procedure Transformation

  • 27. 
    Can we generate alpha-numeric value in sequence generator?
    • A. 

      Yes

    • B. 

      No

  • 28. 
    Which transformation is used by COBOL source?
    • A. 

      Advanced External Procedure Transformation

    • B. 

      Cobol Transformation

    • C. 

      Unstructured Data Transformation

    • D. 

      Normalizer

  • 29. 
    What is VSAM normalizer transformation?
    • A. 

      The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition.

    • B. 

      The VSAM normalizer transformation is the source qualifier transformation for a flat file source definition.

    • C. 

      The VSAM normalizer transformation is the source qualifier transformation for a xml source definition.

    • D. 

      None of these

  • 30. 
    What is the default source option for update strategy?
    • A. 

      Update or Delete

    • B. 

      Update or Insert

    • C. 

      Insert or Update

    • D. 

      Date Driven

  • 31. 
    What are the different values returned by NewLookupRow port?
    • A. 

      0,1,3

    • B. 

      0,1,2

    • C. 

      1,2,3

    • D. 

      2,3,4

  • 32. 
    Which are lookup caches?
    • A. 

      Persistent cache

    • B. 

      Dynamic cache

    • C. 

      Pre-build lookup cache

    • D. 

      Shared Cache

    • E. 

      None of these

  • 33. 
    Which value returned by NewLookupRow port says that Integration Service updates the row in the cache?
    • A. 

      0

    • B. 

      1

    • C. 

      2

    • D. 

      4

  • 34. 
    What are the types of SQL queries you can specify in the SQL transformation?
    • A. 

      Static

    • B. 

      Dynamic

    • C. 

      Cached

  • 35. 
    What is meaning of tracing level?
    • A. 

      Data store in cache

    • B. 

      Data store in database

    • C. 

      Data store in log file

    • D. 

      Data store in buffer

  • 36. 
    Which command has 60seconds time out period?
    • A. 

      Stop

    • B. 

      Abort

    • C. 

      Kill session

  • 37. 
    Which command is similar to 'kill' command in Unix?
    • A. 

      Stop

    • B. 

      Abort

    • C. 

      Kill session

  • 38. 
    Which one contains input and output transformations?
    • A. 

      Mapplet

    • B. 

      Reusable transformation

    • C. 

      Reusable mapping

  • 39. 
    Which one can test multiple conditions?
    • A. 

      Decode

    • B. 

      Else if

    • C. 

      If

    • D. 

      None of these

  • 40. 
    Which dimension is collection of random transactional codes, flags and/or text attributes ?
    • A. 

      Degenerated

    • B. 

      Scd

    • C. 

      Junk

    • D. 

      Confirmed

  • 41. 
    Which one is not a target Option for file on the Servers?
    • A. 

      FTP

    • B. 

      Loader

    • C. 

      MQ

    • D. 

      ERP

  • 42. 
    Which one is not a designer tool creating transformations?
    • A. 

      Transformation developer

    • B. 

      Mapping designer

    • C. 

      Mapplet designer.

    • D. 

      Target designer

  • 43. 
    Which one is not a scheduling options to run a session?
    • A. 

      Run only on demand

    • B. 

      Run once

    • C. 

      Run in six-month

    • D. 

      Run every

    • E. 

      Customized repeat

  • 44. 
    Which one manages connections to the repository from client application?
    • A. 

      Informatica Repository

    • B. 

      Informatica Server

    • C. 

      Repository manager

    • D. 

      All of these

  • 45. 
    How to Generate the Metadata Reports in Informatica?
    • A. 

      From a browser on any workstation

    • B. 

      Form repository

    • C. 

      From Work flow manager

  • 46. 
    Which one is not Target Types on the Server?
    • A. 

      File

    • B. 

      Relational

    • C. 

      ERP

    • D. 

      Vsam

  • 47. 
    What are the processes to do join the tables if the tables have no primary and foreign key relation and no matching port to join?
    • A. 

      Add one dummy port in two sources.

    • B. 

      Use Joiner transformation to join the sources using dummy port

    • C. 

      Use Union

    • D. 

      In expression trans assign '1' to each port

  • 48. 
    Can start and stop single session in concurrent batch?
    • A. 

      Yes

    • B. 

      No

  • 49. 
    Can you copy the batches?
    • A. 

      Yes

    • B. 

      No

  • 50. 
    What are the processes that informatica runs the session?
    • A. 

      DTM

    • B. 

      Server Manager Process

    • C. 

      Load Manager Process

    • D. 

      Server Configuration Process

  • 51. 
    In the Type2 mapping we have three options to recognize the newly added rows. Which one is not belongs to them?
    • A. 

      Version number

    • B. 

      Effective time range

    • C. 

      Effective date Range

    • D. 

      Flag value

  • 52. 
    Which one not in the types of mapping in “getting started wizard"?
    • A. 

      Slowly Growing target

    • B. 

      Simple Pass through mapping

    • C. 

      Simple Pass through target

    • D. 

      None of These

  • 53. 
    What is default join of joiner?
    • A. 

      Full Outer

    • B. 

      Detail Outer

    • C. 

      Normal

    • D. 

      Master Outer

  • 54. 
    What are the types of joins that Joiner transformation supports ?
    • A. 

      Full Outer

    • B. 

      Master Outer

    • C. 

      Normal

    • D. 

      Detail Outer

  • 55. 
    What is the default join of Source Qualifier?
    • A. 

      Left Outer join

    • B. 

      Equi Join

    • C. 

      Inner-equi join

    • D. 

      Outer join

  • 56. 
    What are the types of batches?
    • A. 

      Concurrent

    • B. 

      Dependent

    • C. 

      Sequential

    • D. 

      Circular

  • 57. 
    What are the types of groups in Router transformation
    • A. 

      User defined group

    • B. 

      Multiple Group

    • C. 

      Default Group

    • D. 

      Single Group

  • 58. 
    Which one of these create log files?
    • A. 

      Process manager

    • B. 

      Informatica Server

    • C. 

      Load Manager

    • D. 

      Non of these

  • 59. 
    Dimension tables are denormalized in nature ? True or False
    • A. 

      True

    • B. 

      False

  • 60. 
    Which of these are the types of metadata that stores in repository?
    • A. 

      Reusable transformations

    • B. 

      Source definitions

    • C. 

      Mapplet

    • D. 

      Sessions and workflows

    • E. 

      Target definitions

  • 61. 
    How to Generate the Metadata Reports in Informatica?
    • A. 

      From a browser on any workstation

    • B. 

      Form repository

    • C. 

      From Work flow manager

  • 62. 
    How can we load time dimension?
    • A. 

      Through Sql transformation

    • B. 

      Through Dimensional Loader

    • C. 

      Through Lookup

    • D. 

      Through Store Procedure

  • 63. 
    Which of these are true about look-up cache?
    • A. 

      We use dynamic cache only for connected lookup

    • B. 

      We use dynamic cache to check whether the record already present in the target table are not

    • C. 

      We use dynamic cache only for un-connected lookup

    • D. 

      All of these

  • 64. 
    Which are the load types in Informatica session?
    • A. 

      Bulk

    • B. 

      Terse

    • C. 

      Normal

    • D. 

      All of these

  • 65. 
    In which load type in session we can't recover the session, or can't rollback
    • A. 

      Bulk

    • B. 

      Terse

    • C. 

      Normal

    • D. 

      1 & 2

  • 66. 
    Which load type we should use in case of less amount of data and recover session?
    • A. 

      Verbose

    • B. 

      Normal

    • C. 

      Bulk

    • D. 

      All of these

  • 67. 
    Which of these are measure objects?
    • A. 

      Min

    • B. 

      Max

    • C. 

      Ltrim

    • D. 

      Avg

  • 68. 
    Can you start a batch within a batch?
    • A. 

      True

    • B. 

      False

  • 69. 
    If you want to save the lookup cache files and reuse them the next time the informatica server, which cache you'll use?
    • A. 

      Dynamic cache

    • B. 

      Static cache

    • C. 

      Shared cache

    • D. 

      Persistent cache

  • 70. 
    For look-up, which one is default informatica server cache?
    • A. 

      Static cache

    • B. 

      Shared

    • C. 

      Dynamic

    • D. 

      Re Cache

  • 71. 
    If you want to insert new rows into cache and the target, you should use which cache?
    • A. 

      Static

    • B. 

      Dynamic

    • C. 

      Persistent

    • D. 

      Re-Cache

  • 72. 
    What are the settings that you have to configure in joiner transformation?
    • A. 

      Master and detail source

    • B. 

      Condition of the join

    • C. 

      Type of Source

    • D. 

      Type of join

  • 73. 
    Which lookup cache is read-only?
    • A. 

      Dynamic

    • B. 

      Shared

    • C. 

      Static

    • D. 

      Persistent cache

  • 74. 
    Which cache allows you to share lookup cache among multiple transactions?
    • A. 

      Shared

    • B. 

      Persistence

    • C. 

      Static

    • D. 

      Dynamic

  • 75. 
    If you want to configure the lookup transformation to rebuild the lookup cache, then which cache you should use?
    • A. 

      Dynamic

    • B. 

      Shared

    • C. 

      Re-cache from database

    • D. 

      Re-cache from target

  • 76. 
    While importing the relational source definition from the database, which of thse are the metadata of source that will be imported?
    • A. 

      Source Name

    • B. 

      Database Location

    • C. 

      Data Type

    • D. 

      Key Constraint

    • E. 

      Column Name

  • 77. 
    n session log file which information’s we can find?
    • A. 

      Session Initialization Process

    • B. 

      Session Completion Process

    • C. 

      Error encounter

    • D. 

      Load Summary

    • E. 

      Load manager process

  • 78. 
    How to connect remote database?
    • A. 

      By ftp

    • B. 

      By login to remote server

    • C. 

      By pmcmd

    • D. 

      All of these

  • 79. 
    Which are the ways to update source definitions?
    • A. 

      Edit the definition

    • B. 

      Re-import the definition

    • C. 

      Connect to server

    • D. 

      Connect to repository server

  • 80. 
    How to generate single look-up by using multiple tables?
    • A. 

      By selecting different source

    • B. 

      By selecting dynamic cache

    • C. 

      Write sql override

    • D. 

      Connect to a sql transformation

  • 81. 
    Which one is not a property in sequence generator?
    • A. 

      Start Value

    • B. 

      Re-cycle

    • C. 

      Current Value

    • D. 

      Number of Cached Values

  • 82. 
    What is proc_result in stored procedure transformation?
    • A. 

      User-denied variable

    • B. 

      Mapping variable

    • C. 

      Workflow variable

    • D. 

      System variable

  • 83. 
    Can you generate sequence number without using sequence generator?
    • A. 

      True

    • B. 

      False

  • 84. 
    Can we import source table without using source qualifier? Explanation: For COBOL file sources we can directly use normalizer transformation without using source qualifier
    • A. 

      True

    • B. 

      False

  • 85. 
    Can you connect ports of two output groups, from router transformation to a single target definitions?
    • A. 

      True

    • B. 

      False

  • 86. 
    Session has to run Monday to Saturday not run Sunday how to schedule in informatica ?
    • A. 

      Customized Report

    • B. 

      Weekly option

    • C. 

      Daily option

    • D. 

      None of these

  • 87. 
    Which one of these is a repository object that generates, modifies or passes data?
    • A. 

      Mapping

    • B. 

      Mapplet

    • C. 

      Transformation

    • D. 

      Batch processing

  • 88. 
    Can we use the mapping parameters or variables, created in one mapping into another mapping?
    • A. 

      True

    • B. 

      False

  • 89. 
    Which one of these transformation use cache?
    • A. 

      Update strategy

    • B. 

      Sorter

    • C. 

      Aggregator

    • D. 

      Rank

  • 90. 
    Which statements are correct?
    • A. 

      In Union, we can join two tables without common ports.

    • B. 

      Joiner support heterogeneous join only

    • C. 

      Source Qualifier supports homogeneous join only

    • D. 

      Without common port we can join in joiner also.

  • 91. 
    Which are true sentences?
    • A. 

      Active transformation is the one which do changes in no of rows.

    • B. 

      Active transformation is the one which doesn't change in no of rows.

    • C. 

      Passive transformation is the one which do changes in no of rows.

    • D. 

      Passive transformation is the one which doesn't change in no of rows.

  • 92. 
    Which of this workflow task represents the location of a user-defined event?
    • A. 

      Event-Raise

    • B. 

      Event-Wait

    • C. 

      User_event

    • D. 

      Decision

  • 93. 
    Which one is not a valid constant expression?
    • A. 

      ERROR ('Null not allowed')

    • B. 

      ABORT('Null not allowed')

    • C. 

      SYSDATE

    • D. 

      AVG(IN_SALARY)

  • 94. 
    Can you reverting to original reusable transformation? Explanation: If you change the properties of a reusable transformation in a mapping, you can revert to the original reusable transformation properties by clicking the Revert button. 
    • A. 

      True

    • B. 

      False

  • 95. 
    Which transformation enables you to connect to an HTTP server to use its services and applications?
    • A. 

      Ftp

    • B. 

      Http

    • C. 

      Custom

    • D. 

      Java

  • 96. 
    Which function convert dates to a specific year, month, day, hour, or minute?
    • A. 

      To_date

    • B. 

      To_char

    • C. 

      Trunc

    • D. 

      None of these

  • 97. 
    Which one is not a character function?
    • A. 

      CHRCODE

    • B. 

      LENGTH

    • C. 

      Lower

    • D. 

      All are char functions

  • 98. 
    Which one is not date function?
    • A. 

      ROUND

    • B. 

      TO_DATE

    • C. 

      TRUNC

    • D. 

      ADD_TO_MONTH

  • 99. 
    Which one is not a data cleansing function?
    • A. 

      IS_DATE

    • B. 

      To_date

    • C. 

      REG_MATCH

    • D. 

      LENGTH

  • 100. 
    The transformation language provides two comment specifiers to let you insert comments in expressions. Which are two ways among these?
    • A. 

      /* write here*/

    • B. 

      / write here/

    • C. 

      // write here

    • D. 

      --write here

  • 101. 
    Which one of these is not a built-in constant?
    • A. 

      Null

    • B. 

      True

    • C. 

      Dd_delete

    • D. 

      Ltrim

    • E. 

      False

  • 102. 
    Which one is not a comparison operator?
    • A. 

      ^=

    • B. 

    • C. 

      >=

    • D. 

      ==

  • 103. 
    Which statements are true?
    • A. 

      NULL AND TRUE = NULL

    • B. 

      NULL AND FALSE = FALSE

    • C. 

      NULL AND TRUE = FALSE

    • D. 

      NULL AND FALSE = NULL

  • 104. 
    Can sorter transformation be passive?
    • A. 

      Yes

    • B. 

      No

  • 105. 
    What is :EXT?
    • A. 

      Required when you write an expression that includes a return value from an Expression transformation

    • B. 

      Required when you write an expression that includes a return value from an External Procedure transformation

    • C. 

      Required when you write an expression that includes a return value from an look up Procedure transformation

    • D. 

      Required when you write an expression that includes a return value from an Aggregator Procedure transformation

  • 106. 
    What is :LKP?
    • A. 

      Session

    • B. 

      Workflow

    • C. 

      Control

    • D. 

      Assign

  • 107. 
    What is :SP?
    • A. 

      Required when you write an expression that includes the return value from an connected Look-Up transformation

    • B. 

      Required when you write an expression that includes the return value from an unconnected Look-Up transformation

    • C. 

      Required when you write an expression that includes the return value from an connected Stored Proceduretransformation

    • D. 

      Required when you write an expression that includes the return value from an unconnected Stored Proceduretransformation

  • 108. 
    Which of this is not a task that exists in workflow?
    • A. 

      Session

    • B. 

      Workflow

    • C. 

      Control

    • D. 

      Assign

  • 109. 
    Which one is not a reserve word in informatica?
    • A. 

      NOTSTARTED

    • B. 

      STARTED

    • C. 

      STOPPED

    • D. 

      SUCCEEDED

    • E. 

      KILLED

  • 110. 
    IIF( EMPLOYEE.NAME = 'Rex', 0, 3 ) What this expression says about?
    • A. 

      If Employee name is Rex then update else delete

    • B. 

      If Employee name is Rex then update else reject

    • C. 

      If Employee name is Rex then insert else reject

    • D. 

      If Employee name is Rex then update else insert

  • 111. 
    Which variable doesn't belongs to variable use in transaction control expression?
    • A. 

      TC_COMMIT_BEFORE

    • B. 

      TC_ROLLBACK_AFTER

    • C. 

      TC_ROLLBACK_BEFORE

    • D. 

      TC_COMMIT_AFTER

    • E. 

      TC_CONTINUE_TRANSACTION

  • 112. 
    Which is not a date format string?
    • A. 

      SS , SSSS

    • B. 

      MM, MON, MONTH

    • C. 

      MI

    • D. 

      MM

    • E. 

      HH, HH12, HH24

  • 113. 
    Which statements are correct?
    • A. 

      DATE_DIFF. Subtract two dates

    • B. 

      ADD_TO_DATE. Add or subtract a specific portion of a date

    • C. 

      TO_DATE Change one part of a date to another date format

    • D. 

      SET_DATE_PART. Change one part of a date

  • 114. 
    Which one is not a conversion function?
    • A. 

      TO_MONTH

    • B. 

      TO_DECIMAL

    • C. 

      TO_NUMBER

    • D. 

      TO_INTEGER

    • E. 

      TO_DATE

  • 115. 
    Which one is not a numeric function?
    • A. 

      TRUNC

    • B. 

      LN

    • C. 

      CUME

    • D. 

      ROUND AVG

  • 116. 
    Can you rename the repository object?
    • A. 

      Yes

    • B. 

      No

  • 117. 
    Which are the connection names, those you can configure from work flow manager?
    • A. 

      Relational database connections

    • B. 

      FTP connections

    • C. 

      External loader connections

    • D. 

      Queue connections

    • E. 

      Source and target application connections

  • 118. 
    Integration Service suspends the workflow, if which one of these following tasks fail?
    • A. 

      Session

    • B. 

      Command

    • C. 

      Worklet

    • D. 

      Email

    • E. 

      All of these

  • 119. 
    Which task is used to stop, abort, or fail the top-level workflow or the parent workflow based on an input link condition?
    • A. 

      Command

    • B. 

      Control

    • C. 

      Email

    • D. 

      Timer

  • 120. 
    What is :SEQ?
    • A. 

      Required when you create an expression that includes a port in a Sequence Generator transformation

    • B. 

      Required when you create an Lookup that includes a port in a Sequence Generator transformation

    • C. 

      Required when you create an Sql Transformation that includes a port in a Sequence Generator transformation

    • D. 

      Required when you create an UN-connected lookup Transformation that includes a port in a Sequence Generator transformation

  • 121. 
    Which one is not date function?
    • A. 

      ROUND

    • B. 

      TO_DATE

    • C. 

      TRUNC

    • D. 

      ADD_TO_MONTH

  • 122. 
    If you want to run a second session only if the first session completes successfully, then which task you should use?
    • A. 

      Timer

    • B. 

      Assign

    • C. 

      Decisions

    • D. 

      Link

  • 123. 
    Can you run part of work flow?
    • A. 

      Yes

    • B. 

      No

  • 124. 
    Which tasks are re-usable?
    • A. 

      Control

    • B. 

      Command

    • C. 

      Email

    • D. 

      Session

  • 125. 
    Which task Waits for a user-defined or a predefined event to occur, once the event occurs, the Integration Service completes the rest of the workflow?
    • A. 

      Event-Raise

    • B. 

      Event-Wait

  • 126. 
    If you want to copy the rejected files and paste it in other directory during the running of work-flow, then which task you should use?
    • A. 

      Decisions

    • B. 

      Control

    • C. 

      Command

    • D. 

      Assignment

  • 127. 
    Which one is not a commit type?
    • A. 

      User-defined commit

    • B. 

      Pre-defined commit

    • C. 

      Source-based commit

    • D. 

      Target-based commit

  • 128. 
    What are the types of method to load dimensional table?
    • A. 

      Conventional

    • B. 

      Indirect

    • C. 

      Direct

    • D. 

      None of these

  • 129. 
    What is lookup table?
    • A. 

      Stores the update record based on lookup condition

    • B. 

      Stores the new record based on lookup condition

    • C. 

      Stores the new record or update record based on lookup condition

    • D. 

      None of these

  • 130. 
    Which scd type stores one time historical data with current data?
    • A. 

      Type1

    • B. 

      Type2

    • C. 

      Type3

  • 131. 
    Which SCD methodology overwrites old data with new data?
    • A. 

      Type1

    • B. 

      Type2

    • C. 

      Type3

  • 132. 
    Which SCD method tracks historical data by creating multiple records?
    • A. 

      Type1

    • B. 

      Type2

    • C. 

      Type3

  • 133. 
    What is hybrid SCD?
    • A. 

      Combination of type1 and type2

    • B. 

      Combination of type2 and type3

    • C. 

      Combination of type1 and type3

  • 134. 
    Which schema is normalized?
    • A. 

      Star

    • B. 

      Snowflake

    • C. 

      Galaxy

  • 135. 
    If one table contains a value that is not either measure or fact, what do we call that?
    • A. 

      Additive fact

    • B. 

      Junk dimension

    • C. 

      Semi-additive fact

    • D. 

      De-generated dimension

  • 136. 
    Which type of wizard loads a static fact or dimension table by inserting all rows?
    • A. 

      Mapping Pass Through

    • B. 

      Simple Pass Through

    • C. 

      Slowly Growing Target

    • D. 

      Option 4

  • 137. 
    INSTR( 'Samsung', 'a' ). What will be output?
    • A. 

      True

    • B. 

      False

    • C. 

      0

    • D. 

      2

  • 138. 
    INITCAP( 'mike' ) What is output?
    • A. 

      Mike

    • B. 

      Mike

    • C. 

      MIKE

    • D. 

      None of these

  • 139. 
    What is output of this expression? IN( 'dog', 'cat', 'dog', 'horse', 0 )
    • A. 

      0

    • B. 

      False

    • C. 

      1

    • D. 

      True

  • 140. 
    Which statements are true about FLOOR function?
    • A. 

      FLOOR( 39.9 )=40

    • B. 

      FLOOR( 39.9 )=39

    • C. 

      FLOOR( -39.9 )=-39

    • D. 

      FLOOR( -39.9 )=-40

    • E. 

      FLOOR( 39.2 )=39

  • 141. 
    Which one is true about DATE_COMPARE function?
    • A. 

      Compare two string returns an integer value

    • B. 

      Compare two dates returns an integer value

    • C. 

      Compare two numeric value returns an date value

    • D. 

      Compare two numeric value returns an string value

  • 142. 
    Which one is true about CHR function?
    • A. 

      It’s just opposite to ASCII function

    • B. 

      CHR returns the numeric value to corresponding to the ASCII character

    • C. 

      CHR returns the ASCII character corresponding to the numeric value

    • D. 

      None of these

  • 143. 
    CHOOSE (2, 'Abcd', 'gef', 'ijk' ), What will this function return?
    • A. 

      True

    • B. 

      False

    • C. 

      Gef

    • D. 

      Ijk

  • 144. 
    Which are correct statements?
    • A. 

      CELI(12.39)=12

    • B. 

      CELI(12.39)=13

    • C. 

      CELI(-12.39)=-13

    • D. 

      CELI(-12.39)=-12

    • E. 

      CELI(12.56)=13

  • 145. 
    When you configure the Integration Service to run in ASCII mode, which one is correct about the ASCII function returns value
    • A. 

      Numeric ASCII value of the first & last character of the string passed to the function

    • B. 

      Numeric ASCII value of the last character of the string passed to the function

    • C. 

      Numeric ASCII value of the all character of the string passed to the function

    • D. 

      Numeric ASCII value of the first character of the string passed to the function

  • 146. 
    Which date function specify the part of the date you want to change?
    • A. 

      SET_DATE_PART

    • B. 

      DATE_DIFF

    • C. 

      GET_DATE_PART

    • D. 

      ADD_TO_DATE

  • 147. 
    Which system variable returns the current date and time on the machine hosting the Integration Service for each row passing through the transformation?
    • A. 

      SYSDATE

    • B. 

      $$$SessStartTime

    • C. 

      SESSSTARTTIME

    • D. 

      WORKFLOWSTARTTIME

  • 148. 
    Which system variable returns the current date and time value on the machine hosting the Integration Service when the server initializes the session?
    • A. 

      $$$SessStartTime

    • B. 

      SESSSTARTTIME

    • C. 

      SYSDATE

    • D. 

      WORKFLOWSTARTTIME

  • 149. 
    Which system variable returns the initial system date value on the machine hosting the Integration Service when the server initializes a session?
    • A. 

      $$$SessStartTime

    • B. 

      SESSSTARTTIME

    • C. 

      SYSDATE

    • D. 

      WORKFLOWSTARTTIME

  • 150. 
    Which wizard loads a slowly growing fact or dimension table by inserting new rows?
    • A. 

      Slowly Growing Target

    • B. 

      Rapidly Growing Target

    • C. 

      Simple Pass Through

  • 151. 
    Which one is the correct format of ADD_TO_DATE function?
    • A. 

      ADD_TO_DATE( ORDER_DATE, 1, 'MM' )

    • B. 

      ADD_TO_DATE( ORDER_DATE, 'MM', 1 )

    • C. 

      ADD_TO_DATE(1, ORDER_DATE, 'MM' )

    • D. 

      ADD_TO_DATE(1,MM, ORDER_DATE )

  • 152. 
    Can we perform calulation in Look up?
    • A. 

      Yes

    • B. 

      No

  • 153. 
    Which type of join keeps all rows of data from both the master and detail sources?
    • A. 

      Master outer

    • B. 

      Detail Outer

    • C. 

      Full Outer

    • D. 

      Left Outer

  • 154. 
    Which are the true statement to improve session performance in joiner ?
    • A. 

      Add transformations

    • B. 

      Configure the sort order

    • C. 

      Configure the Joiner transformation

    • D. 

      Do not user master outer join

  • 155. 
    Which type of join join keeps all rows of data from the master source and the matching rows from the detail source?
    • A. 

      Master Outer

    • B. 

      Detail Outer

    • C. 

      Normal

    • D. 

      Equi

  • 156. 
    To maximize session performance what are the tips for filter transformation?
    • A. 

      Use the Filter transformation early in the mapping

    • B. 

      Use the Source Qualifier transformation to filter

    • C. 

      Use the Expression Qualifier transformation to filter

    • D. 

      All of these

  • 157. 
    Is Filter is case-sensitive?
    • A. 

      Yes

    • B. 

      No

  • 158. 
    If two tables emp_detail and emp_payroll contain EMP_ID1 and EMP_ID2 with a row with a null value, can joiner will match that null value?
    • A. 

      True

    • B. 

      False

  • 159. 
    Which type of join keeps all rows of data from the detail source and the matching rows from the master source?
    • A. 

      Master outer

    • B. 

      Detail Outer

    • C. 

      Normal

    • D. 

      Equi

  • 160. 
    Can you use sorted input if source data is data driven?
    • A. 

      True

    • B. 

      False

  • 161. 
    Is [your statement here] true or false?
    • A. 

      True

    • B. 

      False

  • 162. 
    To configure how the Integration Service applies the transformation logic to incoming data, which one you can choose of the following values
    • A. 

      Row

    • B. 

      Transaction

    • C. 

      All Input

    • D. 

      You can choose any one of these

  • 163. 
    Can you use sorted input if the session uses incremental aggregation?
    • A. 

      True

    • B. 

      False

  • 164. 
    Whitch guidelines are needful to optimize the performance of an Aggregator transformation?
    • A. 

      Use sorted input to decrease the use of aggregate caches.

    • B. 

      Limit connected input/output or output ports.

    • C. 

      Filter before aggregating

    • D. 

      None

  • 165. 
    INSTR( 'Vivek', 'a' ). What will be output?
    • A. 

      Null

    • B. 

      False

    • C. 

      0

    • D. 

      None of These

  • 166. 
    Which repository objects is not created in Workflow Manager ?
    • A. 

      Database connections

    • B. 

      Worklet

    • C. 

      Maplet

    • D. 

      Session

  • 167. 
    Which repository objects are created by repository manager?
    • A. 

      Folder

    • B. 

      User

    • C. 

      User type

    • D. 

      User Groups

  • 168. 
    Which statement is true?
    • A. 

      A repository domain consists of no of global repository and any number of local repositories

    • B. 

      A repository domain consists of a single global repository and any number of local repositories

    • C. 

      A repository domain consists of no of global repository and one local repositories

    • D. 

      None of these

  • 169. 
    Which is not a version of objects in the repository
    • A. 

      Check out and check in versioned objects

    • B. 

      Compare objects

    • C. 

      Track changes to an object

    • D. 

      Update a version

  • 170. 
    Where you can release lock if one object is locked?
    • A. 

      Work flow manager

    • B. 

      Designer

    • C. 

      Repository Manager

    • D. 

      None of these

  • 171. 
    If you are comparing two date using date_compare function, if first date is earlier then what will be returned?
    • A. 

      Date difference in number

    • B. 

      Date difference in no of day

    • C. 

      -1

    • D. 

      1

  • 172. 
    If you are comparing two date using date_compare function, if Second date is earlier then what will be returned?
    • A. 

      No of days in number

    • B. 

      No of days in days

    • C. 

      1

    • D. 

      0

  • 173. 
    If you are comparing two date using date_compare function, if two dates are equal then what will be returned?
    • A. 

      1

    • B. 

      -1

    • C. 

      0

    • D. 

      None

  • 174. 
    INSTR( "I am a informatica Developer', 'a', 1, 2 ) What is output?
    • A. 

      3

    • B. 

      4

    • C. 

      5

    • D. 

      6

  • 175. 
    INSTR( "informatica', 'a', -1, 2 ) What is output?
    • A. 

      5

    • B. 

      7

    • C. 

      12

    • D. 

      1

  • 176. 
    What will output? SUBSTR( "Informatica",1,INSTR( "Informatica",1,1 ))
    • A. 

      I

    • B. 

      Atica

    • C. 

      Tica

    • D. 

      Informa

  • 177. 
    LEAST( 12, 13, 21 ) what will output?
    • A. 

      40

    • B. 

      25

    • C. 

      12

    • D. 

      21 

  • 178. 
    LPAD( 190, 5, '0') What will output?
    • A. 

      00000190

    • B. 

      19000000

    • C. 

      00190

    • D. 

      19000

  • 179. 
    LPAD( "Informatica", 16, '*..*' ) What will output?
    • A. 

      *..*Informatica

    • B. 

      *..*.Informatica

    • C. 

      Informatica*..*.

    • D. 

      Informatica*..*

  • 180. 
    LPAD( "Inform", -10, '*') What will out put?
    • A. 

      Inform*****

    • B. 

      *****Inform

    • C. 

      Inform

    • D. 

      Null

  • 181. 
    What will o/p of this expression . 8 * 10 - NULL
    • A. 

      80

    • B. 

      8

    • C. 

      10

    • D. 

      Null

  • 182. 
    What is the return value of 'alpha' || NULL ?
    • A. 

      Alphanull

    • B. 

      Null

    • C. 

      Alpha

    • D. 

      False

  • 183. 
    Which variable sets the current value of a mapping variable to a value you specifyand returns the specified value?
    • A. 

      SETVARIABLE

    • B. 

      Function Syntax Description SETCOUNTVARIABLE

    • C. 

      Function Syntax Description SETCOURENTVARIABLE

    • D. 

      NONE OF THESE

  • 184. 
    Which variable counts the rows evaluated by the function and increments the current value of a mapping based on the count?
    • A. 

      SETMINVARIABLE

    • B. 

      SETVARIABLE

    • C. 

      SETCOUNTVARIABLE

    • D. 

      NONE OF THESE

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

      Truncate table

    • B. 

      Update as Insert

    • C. 

      Update as Update

    • D. 

      Update as Delete

  • 186. 
    What is the meaning of Update as Update?
    • A. 

      Update each row flagged for update if it is not exists in the target table.

    • B. 

      Update each row flagged for update if it exists in the target table

    • C. 

      Update each row flagged for update if it is new in the target table

    • D. 

      None of these

  • 187. 
    What is meaning of Update as Insert in update-strategy?
    • A. 

      Update each row flagged for update if it exists in the target table

    • B. 

      Inset each row flagged for update

    • C. 

      Update the row if it exists. Otherwise, insert it.

    • D. 

      None of these

  • 188. 
    What is meaning of Update as update else Insertin update-strategy?
    • A. 

      Update each row flagged for update if it exists in the target table

    • B. 

      Insert each row flagged for update

    • C. 

      Update the row if it exists. Otherwise, insert it

    • D. 

      All of these

  • 189. 
    Which function causes the Integration Service to skip a record and issue the specified error message?
    • A. 

      ERROR

    • B. 

      ABORT

    • C. 

      SKIP

    • D. 

      ERR

  • 190. 
    ROUND( 112.5676, 3 ). What will output of this expression?
    • A. 

      112

    • B. 

      .567

    • C. 

      112.568

    • D. 

      112.6

  • 191. 
    What is Truncate Table option in update-strategy?
    • A. 

      Truncate the target table before loading data.

    • B. 

      Load the table value to another table

    • C. 

      Delete the data of target which can roll back

    • D. 

      None of these

  • 192. 
    What will o/p of this statement REPLACECHR ( 1, 'Informatica[Scenarios"]', ']["', NULL ) ?
    • A. 

      [InformaticaScenarios]

    • B. 

      "[InformaticaScenarios]"

    • C. 

      "[Informatica[Scenarios"]"

    • D. 

      InformaticaScenarios

  • 193. 
    What will return value of this expression REPLACECHR ( 1, 'RAR", 'R', 'M' )?
    • A. 

      True

    • B. 

      False

    • C. 

      RAM

    • D. 

      MAR

  • 194. 
    ROUND( 10567.90, -2 ). What is the output of this statement?
    • A. 

      10567

    • B. 

      567.90

    • C. 

      10500

    • D. 

      90

  • 195. 
    Which of these are true?
    • A. 

      Drill-down allows the users view higher level

    • B. 

      Drill-down allows the users view lower level

    • C. 

      Drill-up allows the users to view higher level

    • D. 

      Drill-up allows the users to view lower level

  • 196. 
    Which is not a kind of lock on repository objects?
    • A. 

      Execute lock

    • B. 

      Fetch lock

    • C. 

      Save lock

    • D. 

      Read lock

    • E. 

      Delete Lock

  • 197. 
    Which is not true of Cube?
    • A. 

      Multidimensional representation of data

    • B. 

      Used for analysis purpose

    • C. 

      Multiple level of extraction of data

    • D. 

      Multiple views of data

  • 198. 
    What will happen if informatica server doesn't find session parameter and variable?
    • A. 

      Work flow will fail

    • B. 

      Automatically it will created

    • C. 

      Give a message to user to put it

    • D. 

      None of these

  • 199. 
    Which of these are limitationof bulk loading of target load type in Session?
    • A. 

      Less no of record

    • B. 

      Use only Relational Database

    • C. 

      Doesn't support flat file.

    • D. 

      All of these

  • 200. 
    If you are not using group by column in Aggrigaror, what will be out put?
    • A. 

      Not a problem

    • B. 

      Only first row

    • C. 

      Only Last Row

    • D. 

      None of these

  • 201. 
    How many transformation you can use in your mapping?
    • A. 

      16

    • B. 

      16

    • C. 

      Any number according to requirement

    • D. 

      In Informatica 7 limited in 8 unlimited

  • 202. 
    Which transformation acts like CASE.. WHEN in Sql?
    • A. 

      Filter

    • B. 

      Router

    • C. 

      Aggregator

    • D. 

      Look Up

  • 203. 
    Which system is normalized?
    • A. 

      OLTP

    • B. 

      OLAP

  • 204. 
    Data mart is
    • A. 

      Data marts are optimized for INSERT, UPDATE operations

    • B. 

      Data marts are generally designed for different single subject area

    • C. 

      Data marts are generally designed for a single subject area

    • D. 

      None of these

  • 205. 
    Snow flake schema
    • A. 

      Pointing to Dimensional tables itself are pointed by sub Fact tables.

    • B. 

      Pointing to fact tables itself are pointed by sub dimension tables

    • C. 

      Pointing to Datamart itself are pointed by sub dimension tables.

    • D. 

      All of these

  • 206. 
    What is Truncate Table option in update-strategy?
    • A. 

      Truncate the target table before loading data.

    • B. 

      Load the table value to another table

    • C. 

      Delete the data of target which can roll back

    • D. 

      None of these

  • 207. 
    Which of these is not a ETL tools in the Market?
    • A. 

      Decision

    • B. 

      DataStage

    • C. 

      Stream

    • D. 

      Beacon

  • 208. 
    Which of these is not a reporting tool?
    • A. 

      DTS

    • B. 

      Analysis service

    • C. 

      Essbase

    • D. 

      BO

  • 209. 
    Which version of informatica supports data integration for the cloud?
    • A. 

      8.1

    • B. 

      8.2

    • C. 

      9.0

    • D. 

      7.0

  • 210. 
    Can we use sorted input option for incremental aggregation?
    • A. 

      Yes

    • B. 

      No

  • 211. 
    How can you handle multiple matches in lookup transformation?
    • A. 

      By Using "Lookup Match" option

    • B. 

      By Using "Lookup Policy " option

    • C. 

      By Using " Multiple Match" option

    • D. 

      By Using "Lookup Policy on Multiple Match" option

  • 212. 
    What are the processes for creating indexes after loading processes completed?
    • A. 

      By using session level command task

    • B. 

      By Scripting for creating index

    • C. 

      By store procedure

    • D. 

      All of these

  • 213. 
    Which transformation receives input values from the result of a :LKP expression in another transformation?
    • A. 

      Custom

    • B. 

      Connected SP

    • C. 

      Unconnected Look-up

    • D. 

      None of these

  • 214. 
    IIF( Avg(salary) 20000,1,0) Can I set this statement in aggregator transformation?
    • A. 

      Yes

    • B. 

      No

  • 215. 
    Can we use the mapping parameter or variable created in one mapping into Other reusable transformation?
    • A. 

      Yes

    • B. 

      No

  • 216. 
    What is nested aggregate function?
    • A. 

      Takes only one output row

    • B. 

      Returns only multiple output row

    • C. 

      Returns only one output row

    • D. 

      Takes multiple output row

  • 217. 
    Which transformations are both connected and on connected?
    • A. 

      Stored Procedure

    • B. 

      SQL

    • C. 

      Lookup

    • D. 

      External Procedure

  • 218. 
    How can you connect client to your informatica server if server is located in different place i.e not in local client? choose correct answers
    • A. 

      Through pmcmd task

    • B. 

      Through ftp

    • C. 

      Ip address

    • D. 

      Vpn service

  • 219. 
    What is single level aggregate function?
    • A. 

      Returns more than one row

    • B. 

      Returns only one row

    • C. 

      Take input more than one row

    • D. 

      Take input one row