Question Of Informatica

Which one is not correct about filter transformation?

Explanation: Filter generally parses single condition. For multiple condition we can use router

• Act as a 'where' condition (wrong)
• Can't passes multiple conditions (correct)
• Act like 'Case' in pl/sql (wrong)
• If one record does not match condition, the record is blocked (wrong)

Can we calculate in aggrigator ?

Explanation:

• No (wrong)
• Yes (correct)

Which one is not a type of  fact?

Explanation:

• Semi-aditive (wrong)
• Additive (wrong)
• Confirm fact (correct)
• Not additive (wrong)

 Which one is not a type of dimension ?

Explanation:

• Conformed dimension
• Rapidly changing dimension (correct)
• Junk dimension (wrong)
• Degenerated dimension (wrong)

Which of these not correct about Code Page?

Explanation:

• A code page contains encoding to specify characters in a set of one or more languages (wrong)
• A code page contains decoding to specify characters in a set of one or more languages (correct)
• In this way application stores, receives, and sends character data. (wrong)
• Non of these (wrong)

What is a mapplet?

Explanation:

• Combination of reusable transformation. (wrong)
• Set of transformations and it allows us to reuse (correct)
• Non of these

What does reusable transformation mean?

Explanation:

• It can be re-used across repositories (wrong)
• I can only be used in mapplet.
• It can use in multiple mapping only once (wrong)
• It can use in multiple mapping multiple times (correct)

Which one is not an option in update strategy?

Explanation:

• dd_reject (wrong)
• 4 (correct)
• 2 (wrong)
• dd_delete (wrong)

Can we update records without using update strategy?

Explanation:

• Yes (correct)
• No (wrong)

How to select distinct records form Source Qualifier?

Explanation:

• Choose 'non duplicate' option
• Choose 'select distinct' option (correct)
• Choose 'Select non duplicate'

What type of repository is no available in Informatica Repository Manager?

Explanation:

• Standalone Repository
• Local Repository (wrong)
• User Defined (correct)
• Versioned Repository (wrong)
• Manual Repository (wrong)

Joiner does not support flat file.

Explanation:

• False (correct)
• True (wrong)

How to execute PL/SQL script from Informatica mapping?

Explanation:

• Lookup (wrong)
• Store Procdure (correct)
• Expression (wrong)
• Non of these (wrong)

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

Explanation:

• Aggrigator (wrong)
• Lookup
• Filter
• Expression (correct)

Which one is not an active transformation?
 

Explanation:

• Sequence generator (correct)
• Normalizer (wrong)
• Sql (wrong)
• Store Procedure (wrong)

A lookup transformation is used to look up data in
 

Explanation:

• flat file
• Relational table (wrong)
• view
• synonyms
• All of the above (correct)

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

Explanation:

• 3 (wrong)

• 2
• 1 (wrong)
• 0 (correct)

Which one need a common key to join?
 

Explanation:

• source qualifier (wrong)
• joiner (correct)
• look up (wrong)

Which one support hetrogeneous join?
 

Explanation:

• source qualifier (wrong)
• joiner (correct)
• look up (wrong)

What is the use of target loader?
 

Explanation:

• Target load order is first the data is load in dimension table and then fact table. (correct)
• Target load order is first the data is load in fact table and then dimensional table. (wrong)
• Load the data from different target at same time. (wrong)

Which one is not tracing level?
 

Explanation:

• terse
• verbose (wrong)
• initialization (wrong)
• verbose initialization (wrong)
• terse initialization (correct)

Which output file is not created during  session running?
 

Explanation:

• Session log (wrong)
• workflow log
• Error log
• Bad files (wrong)
• cache files (correct)

Is Fact table is normalised ?
 

Explanation:

• yes (wrong)
• no (correct)

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

Explanation:

• 0 (wrong)
• 2 (wrong)
• 3

Which transformation only works on relational source?

 

Explanation:

• lookup (wrong)
• Union (wrong)
• joiner
• Sql (correct)

Which are  both connected and unconnected?
 

Explanation:

• External Store Procedure (correct)
• External Store Procedure (omitted)
• External Store Procedure (correct)
• Stote Procedure (correct)
• Stote Procedure (omitted)
• Stote Procedure
• Lookup (omitted)
• Lookup (correct)
• Lookup
• Lookup (correct)
• Advanced External Procedure Transformation (wrong)
• Advanced External Procedure Transformation

Can we generate alpha-numeric value in sequence generator?
 

Explanation:

• yes (wrong)
• no (correct)

Which transformation is used by cobol source?
 

Explanation:

• Advanced External Procedure Transformation
• Cobol Transformation (wrong)
• Unstructured Data Transformation
• Normalizer (correct)

What is VSAM normalizer transformation?
 

Explanation:

• The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition. (correct)
• The VSAM normalizer transformation is the source qualifier transformation for a xml source definition. (wrong)
• Non of these

What is VSAM normalizer transformation?
 

Explanation:

• The VSAM normalizer transformation is the source qualifier transformation for a COBOL source definition. (correct)
• The VSAM normalizer transformation is the source qualifier transformation for a xml source definition. (wrong)
• Non of these

Which are  lookup caches?
 

Explanation:

• Persistent cache (correct)
• Persistent cache (omitted)
• Persistent cache
• Dynamic cache (correct)
• Dynamic cache (omitted)
• Dynamic cache
• Pre-build lookup cache (omitted)
• Pre-build lookup cache (correct)
• Pre-build lookup cache
• Shared Cache (correct)
• Shared Cache (omitted)
• Shared Cache
• Non of these (wrong)
• Non of these

What are the different values returned by NewLookupRow port?
 

Explanation:

• 0,1,3
• 0,1,2 (correct)
• 1,2,3 (wrong)
• 2,3,4

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

Explanation:

• 0 (wrong)
• 1 (wrong)
• 2 (correct)
• 4

What are the types of SQL queries you can specify in the SQL transformation?
 

Explanation:

• strict (omitted)
• strict (correct)
• strict
• strict (omitted)
• strict
• Dynamic (correct)
• Dynamic (omitted)
• Dynamic
• Cached (wrong)
• Cached (wrong)
• Cached

What is meanig of tracing level?
 

Explanation:

• Data store in cache (wrong)
• Data store in database
• Data store in logfile (correct)
• Data store in buffer

Which command has 60seconds time out period?

Explanation:

• stop (wrong)
• abort (correct)
• kill session

Which command is similar to'kill'command in unix?
 

Explanation:

• stop
• abort (correct)
• kill session (wrong)

Which one contains contains input and output transformations?
 

Explanation:

• maplet (correct)
• reusable transformation
• reusable mapping (wrong)

Which one can test multiple condition?
 

Explanation:

• decode (wrong)
• else if (wrong)
• if (correct)
• non of these

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

Explanation:

• degenerated (wrong)
• scd
• junk (correct)
• confirmed

Which one is not a target Option for file on the Servers?
 

Explanation:

• FTP (wrong)
• Loader
• MQ (wrong)
• ERP (correct)

Which one is not a designer tool creating tranformations?
 

Explanation:

• Transformation developer
• Mapping designer
• Mapplet designer. (wrong)
• target designer (correct)

Which one is not a  scheduling options to run a sesion?
 

Explanation:

• Run only on demand
• Run once (wrong)
• Run in sixmonth (correct)
• Run every
• Customized repeat

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

Explanation:

• Informatica Repository (correct)
• Informatica Server
• Repository manager (wrong)
• All of these (wrong)

How to Generate the Metadata Reports in Informatica?
 

Explanation:

• From a browser on any workstation (correct)
• Form repository (wrong)
• From Work flow manager (wrong)

Whis one is not Target Types on the Server?
 

Explanation:

• File
• Relational (wrong)
• ERP (wrong)
• vsam (correct)

What are the proceses to do  join the tables if the tables have no primary and forien key relation and no matchig port to join?

Explanation:

• Add one dummy port in two sources. (omitted)
• Add one dummy port in two sources. (correct)
• Add one dummy port in two sources. (omitted)
• Add one dummy port in two sources.
• Use Joiner transformation to join the sources using dummy port (correct)
• Use Joiner transformation to join the sources using dummy port
• Use Union (wrong)
• Use Union
• In expression trans assign '1' to each port (omitted)
• In expression trans assign '1' to each port (correct)
• In expression trans assign '1' to each port

Can  start and stop single session in concurent batch?

Explanation:

• yes (correct)
• no

Can you copy the batches?

Explanation:

• yes (wrong)
• no (correct)

What are the   processes that informatica runs the session?

Explanation:

• DTM (omitted)
• DTM (correct)
• DTM (omitted)
• DTM
• Server Manager Process (wrong)
• Server Manager Process
• Load Manager Process (correct)
• Load Manager Process (omitted)
• Load Manager Process
• Server Configuration Process

What is the default source option for update stratgey ?

Explanation:

• Update or Delete
• Update or Insert (wrong)
• Date Driven (correct)

Which one not in the types of maping  in " getting  started wizard"?

Explanation:

• Slowly Growing target (wrong)
• Simple Pass through target (correct)
• Non of These

Waht is default join of joiner?

Explanation:

• Full Outer
• Detail Outer (wrong)
• Normal (correct)
• Master Outer

What are the types of joins  that  Joiner transformation supports ?

Explanation:

• Full Outer (correct)
• Full Outer (correct)
• Full Outer
• Full Outer
• Master Outer (correct)
• Master Outer (omitted)
• Master Outer (correct)
• Master Outer
• Normal (correct)
• Normal
• Detail Outer (correct)
• Detail Outer (omitted)
• Detail Outer (correct)
• Detail Outer

What is the default join of Source Qualifier?

Explanation:

• Left Outer join
• Equi Join
• Inner-equi join (correct)
• Outer join (wrong)
• Outer join (wrong)

What are the types of batches?

Explanation:

• Concurrent (correct)
• Concurrent (omitted)
• Concurrent
• Dependant (wrong)
• Sequential (correct)
• Sequential (omitted)
• Sequential
• Circular

What are the types of groups in Router transformation?

Explanation:

• User defined group (correct)
• User defined group (omitted)
• User defined group
• Multiple Group (wrong)
• Default Group (correct)
• Default Group (omitted)
• Default Group (correct)
• Single Group

Which one of these create log files?

Explanation:

• process manager
• Informatica Server (wrong)
• Load Manager (correct)
• Non of these

Dimenstion tables are denormalized in nature ? True or False.

Explanation:

• true (correct)
• false (wrong)

Which of these are  the types of metadata that stores in repository?

Explanation:

• Reusable transformations (correct)
• Reusable transformations (omitted)
• Reusable transformations
• Source definitions (correct)
• Source definitions (correct)
• Source definitions (correct)
• Source definitions (correct)
• Source definitions (omitted)
• Source definitions
• maplet (omitted)
• maplet (correct)
• maplet
• Sessions and workflows (correct)
• Sessions and workflows (omitted)
• Sessions and workflows
• Target definitions (correct)
• Target definitions (omitted)
• Target definitions
•  

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

Explanation:

• Version number (wrong)
• Effective time range (correct)
• Effective date Range (wrong)
• flag value (wrong)

How to Generate the Metadata Reports in Informatica?
 

Explanation:

• From a browser on any workstation (correct)
• Form repository (wrong)
• From Work flow manager (wrong)

How can we load time dimension?

Explanation:

• Through Sql transformation (wrong)
• Through Dimensional Loader (wrong)
• Through Lookup (wrong)
• Through Store Procdure

Which of these are true about look-up cache?

Explanation:

• We use dynamic cache only for connected lookup (correct)
• We use dynamic cache only for connected lookup (omitted)
• We use dynamic cache only for connected lookup
• We use dynamic cache to check whether the record already present in the target table are not (correct)
• We use dynamic cache to check whether the record already present in the target table are not (omitted)
• We use dynamic cache to check whether the record already present in the target table are not
• We use dynamic cache only for un-connected lookup
• All of these

Which are the load types in Informatica session?

Explanation:

• Bulk (correct)
• Bulk (omitted)
• Bulk
• Terse
• Normal (correct)
• Normal
• All of these (wrong)
• All of these

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

Explanation:

• bulk (correct)
• terse
• normal
• 1 and 2

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

Explanation:

• verbose
• normal (correct)
• bulk
• All of these

Which of these are measure objects?

Explanation:

• min (omitted)
• min (correct)
• min
• max (omitted)
• max (correct)
• max
• ltrim (wrong)
• ltrim (wrong)
• ltrim
• avg (omitted)
• avg (correct)

Can you start a batch within a batch?

Explanation:

• yes (correct)
• no (wrong)

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

Explanation:

• Dynamic cache
• Static cache
• Shared cache (wrong)
• Persistent cache (wrong)

For look-up , which one is default informatica server  cache?

Explanation:

• Static cache (correct)
• shared
• dynamic (wrong)
• re-cache

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

Explanation:

• static
• dynamic (correct)
• Persistent (wrong)
• Re-cache (wrong)

What are the settings that you have  to configure in joiner transformation?

Explanation:

• Master and detail source (omitted)
• Master and detail source (correct)
• Master and detail source (omitted)
• Master and detail source
• Condition of the join (correct)
• Condition of the join
• Type of Source (wrong)
• Type of join (omitted)
• Type of join (correct)
• Type of join

Which lookup cache is read-only?

Explanation:

• dynamic
• shared
• static (correct)
• Persistent cache

Which cache allows you to share lookup cache among multiple transaction?

Explanation:

• shared (correct)
• persistence
• static
• dynamic

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

Explanation:

• Dynamic
• Shared
• Re-cache from database (correct)
• Re-cache from target (wrong)

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

Explanation:

• Source name (correct)
• Source name
• )
• Source name (correct)
• Source name
• Database location (omitted)
• Database location
• Database location (omitted)
• Database location (correct)
• Database location (omitted)
• Database location
• Data type (correct)
• Key constraints (omitted)
• Key constraints
• Key constraints (correct)
• Key constraints (omitted)
• Key constraints
• Column name (correct)
• Column name
• Column name (correct)
• Column name (correct)
• Column name (correct)
• Column name

How can we load time dimension?

Explanation:

• Through Sql transformation (wrong)
• Through Dimensional Loader (wrong)
• Through Lookup (wrong)
• Through Lookup (wrong)
• Through Lookup (wrong)
• Through Store Procdure

Which of these are true about look-up cache?

Explanation:

• We use dynamic cache only for connected lookup (correct)
• We use dynamic cache only for connected lookup (correct)
• We use dynamic cache only for connected lookup (correct)
• We use dynamic cache only for connected lookup (correct)
• We use dynamic cache only for connected lookup (omitted)
• We use dynamic cache only for connected lookup
• We use dynamic cache to check whether the record already present in the target table are not (correct)
• We use dynamic cache to check whether the record already present in the target table are not (omitted)
• We use dynamic cache to check whether the record already present in the target table are not (correct)
• We use dynamic cache to check whether the record already present in the target table are not (correct)
• We use dynamic cache to check whether the record already present in the target table are not (correct)
• We use dynamic cache to check whether the record already present in the target table are not
• We use dynamic cache only for un-connected lookup
• All of these

Which are the load types in Informatica session?

Explanation:

• Bulk (correct)
• Terse
•  
• Normal (correct)
• Normal
• All of these (wrong)
• All of these

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

Explanation:

• bulk (correct)
• bulk (correct)
• bulk (correct)
• bulk (correct)
• bulk (correct)
• terse
• normal
• 1 and 2

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

Explanation:

• verbose
• normal (correct)
• normal (correct)
• normal (correct)
• normal (correct)
• normal (correct)
• bulk
• All of these

Which of these are measure objects?

Explanation:

• min (omitted)
• min (correct)
• min (correct)
• min (correct)
• min (omitted)
• min
• max (omitted)
• max (correct)
• max (correct)
• max (correct)
• max (omitted)
• max
• ltrim (wrong)
• ltrim (wrong)
• ltrim
• avg (omitted)
• avg (correct)
• avg (correct)
• avg (correct)
• avg (omitted)
• avg

Can you start a batch within a batch?

Explanation:

• yes (correct)
• no (wrong)

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

Explanation:

• Dynamic cache
• Static cache
• Shared cache (wrong)
• Persistent cache (wrong)

For look-up , which one is default informatica server  cache?

Explanation:

• Static cache (correct)
• shared
• dynamic (wrong)
• re-cache

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

Explanation:

·         static

·         dynamic (correct)

·         Persistent (wrong)

·         Re-cache (wrong)

What are the settings that you have  to configure in joiner transformation?

Explanation:

• Master and detail source (omitted
• Master and detail source (correct)
• Master and detail source (omitted)
• Master and detail source
•  
• Condition of the join (correct)
• Condition of the join
• Type of Source (wrong)
• Type of Source (wrong)
• Type of Source
• Type of join (correct)
• Type of join (correct)
• Type of join

Which lookup cache is read-only?

Explanation:

• dynamic
• shared
• static (correct)
• Persistent cache

Which cache allows you to share lookup cache among multiple transaction?

Explanation:

• shared (correct)
• persistence
• static
• dynamic

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

Explanation:

• Dynamic
• Shared
• Re-cache from database (correct)
• Re-cache from target (wrong)

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

Explanation:

• Source name
• Source name (correct)
• Source name
• Database location (omitted)
• Database location
• Database location (omitted)
• Database location (correct)
• Database location (omitted)
• Database location
• Data type (correct)
• Data type
• Data type (correct)
• Data type
• Key constraints (omitted)
• Key constraints
• Key constraints (correct)
• Key constraints (omitted)
• Key constraints
• Column name (correct)
• Column name

How can we load time dimension?

Explanation:

• Through Sql transformation (wrong)
• Through Dimensional Loader (wrong)
• Through Lookup (wrong)
• Through Lookup (wrong)
• Through Lookup (wrong)
• Through Store Procdure

Which of these are true about look-up cache?

Explanation:

• We use dynamic cache only for connected lookup (correct)
• We use dynamic cache only for connected lookup (omitted)
• We use dynamic cache only for connected lookup
• We use dynamic cache to check whether the record already present in the target table are not (correct)
• We use dynamic cache to check whether the record already present in the target table are
• We use dynamic cache only for un-connected lookup
• All of these

Which are the load types in Informatica session?

Explanation:

• Bulk (omitted)
• Bulk (correct)
• Bulk
• Terse
• Normal (correct)
• Normal
• All of these (wrong)
• All of these

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

Explanation:

• bulk (correct)
• terse
• normal
• 1 and 2

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

Explanation:

• verbose
• normal (correct)
• bulk
• All of these

Which of these are measure objects?

Explanation:

• min (omitted)
• min (correct)
• min (omitted)
• max (omitted)
• max (correct)
• ltrim (wrong)
• ltrim
• avg (omitted)
• avg (correct)

Can you start a batch within a batch?

Explanation:

• yes (correct)
• no (wrong)

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

Explanation:

• Dynamic cache
• Static cache
• Shared cache (wrong)
• Persistent cache (wrong)

For look-up , which one is default informatica server  cache?

Explanation:

• Static cache (correct)
• shared
• dynamic (wrong)
• re-cache

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

Explanation:

• static
• dynamic (correct)
• Persistent (wrong)
• Re-cache (wrong)

What are the settings that you have  to configure in joiner transformation?

Explanation:

• Master and detail source (correct)
• Condition of the join (correct)
• Type of Source (wrong)
• Type of join (correct)

Which lookup cache is read-only?

Explanation:

• dynamic
• shared
• static (correct)
• Persistent cache

Which cache allows you to share lookup cache among multiple transaction?

Explanation:

• shared (correct)
• persistence
• static
• dynamic

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

Explanation:

• Dynamic
• Shared
• Re-cache from database (correct)
• Re-cache from target (wrong)

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

Explanation:

• Source name (correct)
• Database location (omitted)
• Data type (correct)
• Key constraints (correct)
• Column name (correct)

In session log file which informations we can find?

Explanation:

• Session Initialization Process (correct)
• Session Completion Process (wrong)
• Error encounter (correct)
• Load Summary (correct)
• Load manager process (wrong)

How to connect remote database?

Explanation:

• By ftp (correct)
• By login to remote server (wrong)
• By pmcmd
• All of these

Which are the  ways to  update source definitions?

Explanation:

• Edit the definition (correct)
• Re-import the definition (correct)
• connect to server (wrong)
• connect to repository server (wrong)

How to generate single look-up by using multiple tables?

Explanation:

• By selecting different source (wrong)
• Write sql override (correct)
• Connect to a sql transformation

Which one is not a properties in sequence generator?

Explanation:

• Start Value
• re-cycle (correct)
• Current Value
• Number of Cached Values (wrong)

What is proc_result  in stored procedure transformation?

Explanation:

• user-denied variable (wrong)
• mapping variable (wrong)
• workflow variable
• system variable (correct)

Can you generate sequence number without using sequence generator?

Explanation: By using expression

• yes (correct)
• no (wrong)

can we import source table without using source qualifier?

Explanation: For cobol file sources we can directly use normalizertransformation without using source qualifier

• yes (correct)
• no (wrong)

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

Explanation:

• yes (correct)
• no (wrong)

session has to run Monday to Saturday not run sunday how to sedule in informatica ?

Explanation:

• Customized Report (correct)
• weekly option (wrong)
• daily option
• non of these

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

Explanation:

• mapping (wrong)
• transformation (correct)
• batch processing

Can we use the mapping parameters or variables,created in one mapping into another mapping?

Explanation:

• no (correct)
• yes

Which one of these transformation  use cache?

Explanation:

• Update Startegy (wrong)
• sorter (correct)
• Aggregator (correct)
• Rank (correct)

Which statements are correct?

Explanation:

• In Union, we can join two tables without common ports. (correct)
• Joiner support heterogeneous join only (wrong)
• Source Qualifier supports homogeneous join only (wrong)
• Without common port we can join in joiner also.

Which are true sentences?

Explanation:

• Active transformation is the one which do changes in no of rows. (correct)
• Active transformation is the one which doesn't change in no of rows. (wrong)
• Passive transformation is the one which doesn't change in no of rows. (correct)

Which of of these workflow task, represents the location of a user-defined event?

Explanation:

• Event-Raise (correct)
• User_event (wrong)
• Decision (wrong)

Which one is not a vallid constant expression?

Explanation:

• ERROR ('Null not allowed') (wrong)
• SYSDATE
• AVG(IN_SALARY) (correct)

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

• yes (correct)
• no (wrong)

Which transformation enables you to connect to an HTTP server to use its services and applications?

Explanation:

• ftp (wrong)
• http (correct)
• custom (wrong)
• java

Which function convert dates to a specific year, month, day, hour, or minute?

Explanation:

• to_char (wrong)
• trunc (correct)
• non of these

Which one is not a character function?

Explanation:

• CHRCODE (wrong)
• LENGTH
• lower
• All are char functions (correct)

Which one is not date function?

Explanation:

• ROUND
• TO_DATE
• TRUNC (wrong)
• ADD_TO_MONTH (correct)

Which one is not a data cleansing function?

Explanation:

• IS_DATE (wrong)
• To_date (wrong)
• REG_MATCH (wrong)
• LENGTH (correct)

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

Explanation:

• /* write here*/ (wrong)
• / write here/ (wrong)
• // write here (correct)
• --write here (correct)

Which one of these is not a built-in constant?

Explanation:

• Null (wrong)
• True
• dd_delete (wrong)
• ltrim (correct)
• false

Which one is not a comparison operator?

Explanation:

• <= (wrong)
• >=
• == (correct)

Which statements are true?

Explanation:

• NULL AND TRUE = NULL (correct)
• NULL AND TRUE = NULL (correct)
• NULL AND TRUE = NULL (omitted)
• NULL AND TRUE = NULL (omitted)
• NULL AND TRUE = NULL (correct)
• NULL AND TRUE = NULL (correct)
• NULL AND TRUE = NULL (omitted)
• NULL AND TRUE = NULL
• NULL AND FALSE = FALSE (omitted)
• NULL AND FALSE = FALSE (omitted)
• NULL AND FALSE = FALSE (correct)
• NULL AND FALSE = FALSE (correct)
• NULL AND FALSE = FALSE (correct)
• NULL AND FALSE = FALSE (omitted)
• NULL AND FALSE = FALSE (correct)
• NULL AND FALSE = FALSE
• NULL AND TRUE = FALSE (wrong)
• NULL AND TRUE = FALSE
• NULL AND FALSE = NULL (wrong)
• NULL AND FALSE = NULL (wrong)
• NULL AND FALSE = NULL (wrong)
• NULL AND FALSE = NULL

Can sorter transformation be  passive?

Explanation: If we'll not choose sorted input in sorter, then input and output will same. So then it is passive

• yes (correct)
• no

What is :EXT?

Explanation:

• Required when you write an expression that includes a return value from an External Procedure transformation (correct)
• Required when you write an expression that includes a return value from an look up Procedure transformation
• Required when you write an expression that includes a return value from an Agrigator Procedure transformation (wrong)

Waht is :LKP?

Explanation:

• Required when you create an expression that includes the return value from an unconnected Lookup transformation. (correct)
• Required when you create an expression that includes the return value from an Connected Lookup transformation. (wrong)
• Required when you create an expression that includes the return value from an unconnected Sp transformation.
• includes the return value from an connected Sp transformation.

Which of this is not a task that exist in workflow?

Explanation:

• Session
• Workflow (correct)
• control (wrong)
• assign (wrong)

Wat is :SP?

Explanation:

• Required when you write an expression that includes the return value from an connected Look-Up transformation
• Required when you write an expression that includes the return value from an unconnected Look-Up transformation (wrong)
• Required when you write an expression that includes the return value from an connected Stored Procedure transformation
• Required when you write an expression that includes the return value from an unconnected Stored Procedure transformation (correct)

Which one is not a reserve word in informatica?

Explanation:

• NOTSTARTED (wrong)
• STARTED
• STOPPED (wrong)
• KILLED (correct)

IIF( EMPLOYEE.NAME = 'Rex', 0, 3 )

What this expression says about?

Explanation:

• If Employee name is Rex then update else delete (wrong)
• If Employee name is Rex then insert else reject (correct)
• If Employee name is Rex then update else insert (wrong)

Which variable doesn't belongs to variable use in transaction control expression?

Explanation:

• TC_COMMIT_BEFORE
• TC_ROLLBACK_AFTER (correct)
• TC_ROLLBACK_BEFORE (wrong)
• TC_COMMIT_AFTER
• TC_CONTINUE_TRANSACTION (wrong)

Which is not a date format string?

Explanation:

• SS , SSSS (wrong)
• MM, MON, MONTH (wrong)
• MI (wrong)
• MM (correct)
• HH, HH12, HH24

Which statements are correct?

Explanation:

• DATE_DIFF. Subtract two dates (correct)
• ADD_TO_DATE. Add or subtract a specific portion of a date (correct)
• TO_DATE Change one part of a date to another date format (wrong)
• SET_DATE_PART. Change one part of a date (correct)

Which one is not a conversion function?

Explanation:

• TO_MONTH (correct)
• TO_DECIMAL (wrong)
• TO_NUMBER (wrong)
• TO_INTEGER
• TO_DATE (wrong)

Which one is not a numeric function?

Explanation:

• TRUNC
• LN (wrong)
• LN (wrong)
• CUME (wrong)
• ROUND AVG (correct)

Can you rename the repository object?

Explanation: You can rename repository objects by clicking the Rename button in the Edit Tasks dialog box

• yes (correct)
• no (wrong)

Which are the connection names, those you can configure from work flow manager?

Explanation:

• relational database connections (correct)
• FTP connections (correct)
• external loader connections (correct)
• queue connections
• source and target application connections (correct)

Integration Service suspends the workflow, if which one of these following tasks fail?

Explanation:

• Session (wrong)
• Command
• Worklet (wrong)
• Email (wrong)
• All of these (correct)

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

Explanation:

• command (wrong)
• control (correct)
• email (wrong)
• timer

Waht is :SEQ?

Explanation:

• Required when you create an expression that includes a port in a Sequence Generator transformation (correct)
• Required when you create an Lookup that includes a port in a Sequence Generator transformation (wrong)
• Required when you create an Sql Transformation that includes a port in a Sequence Generator transformation (wrong)
• Required when you create an UN-connected lookup Transformation that includes a port in a Sequence Generator transformation

Which one is not date function?

Explanation:

• ROUND (wrong)
• TO_DATE (wrong)
• TRUNC (wrong)
• ADD_TO_MONTH (correct)

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

Explanation:

• timer
• assign
• decisions (correct)
• link (wrong)

Can you run part of work flow?

Explanation: To run part of the workflow, right-click the task that you want the Integration Service to run and choose Start Workflow From Task

• yes (correct)
• co (wrong)

Which tasks are re-usable?

Explanation:

• Control (wrong)
• Command (correct)
• Email (correct)
• Session (correct)

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?

Explanation:

• Event-Raise (wrong)
• Event-Wait (correct)

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?

Explanation:

• decisions
• control (wrong)
• command (correct)
• assignment

Which one is not a commit type?

Explanation:

• User-defined commit (wrong)
• Pre-defined commit (correct)
• Source-based commit (wrong)
• Target-based commit

What are the types of method to load dimensional table?

Explanation:

• Conventional (correct)
• Indirect (wrong)
• Direct (correct)
• Non of these

What is lookup table?

Explanation:

• stores the update record record based on lookup condition (wrong)
• stores the new record or update record based on lookup condition (correct)
• non of these (wrong)

Whch scd type stores  one time historical data with current data?

Explanation:

• type1 (wrong)
• type2 (wrong)
• type3 (correct)

Which SCD methodology overwrites old data with new data?

Explanation:

• type1 (correct)
• type2
• type3

Which SCD method tracks historical data by creating multiple records?

Explanation:

• type1 (wrong)
• type2 (correct)
• type3 (wrong)

What is hybrid SCD?

Explanation:

• combinition of type1 and type2 (correct)
• combinition of type2 and type3 (wrong)
• combinition of type1 and type3

Which schema is normalized?

Explanation:

• star
• snowflake (correct)
• galaxy (wrong)

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

Explanation:

• additive fact (wrong)
• junk dimension (wrong)
• semi-additive fact (wrong)
• De-generated dimension (correct)

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

Explanation:

• Mapping Pass Through (wrong)
• Simple Pass Through (correct)
• Slowly Growing Target (wrong)

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

Explanation:

• true
• false
• 0
• 2 (correct)

INITCAP( 'mike' ) What is output?

Explanation:

• Mike (correct)
• mike
• mIKE
• Non of these

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

Explanation:

• 0 (correct)
• false
• 1
• true

Which statements are true about FLOOR function?

Explanation:

• FLOOR( 39.9 )=40
• FLOOR( 39.9 )=39 (correct)
• FLOOR( 39.9 )=39 (correct)
• FLOOR( -39.9 )=-39 (wrong)
• FLOOR( -39.9 )=-40 (correct)
• FLOOR( 39.2 )=39 (correct)
• FLOOR( 39.2 )=39 (correct)

Which one is true about DATE_COMPARE function?

Explanation:

• compare two string returns an integer value (wrong)
• compare two dates returns an integer value (correct)
• compare two numeric value returns an date value (wrong)
• compare two numeric value returns an string value

Which one is true about CHR function?

Explanation:

• It't just opposite to ASCII function (wrong)
• CHR returns the numeric value to corresponding to the ASCII character (wrong)
• CHR returns the ASCII character corresponding to the numeric value (correct)
• non of these

CHOOSE( 2, 'Abcd', 'gef', 'ijk' ), What will this function return?

Explanation:

• true
• false
• gef (correct)
• ijk

Which are correct statements?

Explanation:

• CELI(12.39)=12 (wrong)
• CELI(12.39)=13 (correct)
• CELI(-12.39)=-13
• CELI(-12.39)=-13
• CELI(-12.39)=-12 (correct)
• CELI(12.56)=13 (correct)

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

Explanation:

• numeric ASCII value of the first & last character of the string passed to the function
• numeric ASCII value of the last character of the string passed to the function (wrong)
• numeric ASCII value of the all character of the string passed to the function
• numeric ASCII value of the first character of the string passed to the function (correct)

Which date function  specify the part of the date you want to change?

Explanation:

• SET_DATE_PART (wrong)
• DATE_DIFF (wrong)
• GET_DATE_PART
• ADD_TO_DATE (correct)

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

Explanation:

• SYSDATE (correct)
• $$$SessStartTime
• SESSSTARTTIME (wrong)
• WORKFLOWSTARTTIME

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

Explanation:

• $$$SessStartTime
• SESSSTARTTIME (correct)
• SYSDATE
• WORKFLOWSTARTTIME

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

Explanation:

• $$$SessStartTime (correct)
• SESSSTARTTIME (wrong)
• SYSDATE
• WORKFLOWSTARTTIME (wrong)

Which wizard loads a slowly growing fact or dimension table by inserting new rows?

Explanation:

• Slowly Growing Target (correct)
• Rapidly Growing Target
• Simple Pass Through (wrong)

Which one is the correct format of ADD_TO_DATE function?

Explanation:

• ADD_TO_DATE( ORDER_DATE, 1, 'MM' )
• ADD_TO_DATE( ORDER_DATE, 'MM', 1 ) (correct)
• ADD_TO_DATE(1, ORDER_DATE, 'MM' )
• ADD_TO_DATE(1,MM, ORDER_DATE )

Can we perform calulation in Look up?

Explanation:

• yes (correct)
• no (wrong)

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

Explanation:

• Master outer
• Detail Outer
• Full Outer (correct)
• left Outer

Which are the true statement to improve session performance in joiner ?

Explanation:

• Add transformations (correct)
• Configure the sort order (correct)
• Configure the Joiner transformation (correct)
• Do not user master outer join

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

Explanation:

• Master Outer (wrong)
• Detail Outer (correct)
• Notmal
• Equi

To maximize session performance what are the tips for filter transformation?

Explanation:

• Use the Filter transformation early in the mapping (correct)
• Use the Source Qualifier transformation to filter (correct)
• Use the Expression Qualifier transformation to filter (wrong)
• All of these (wrong)

Is Filter is case-sensitive?

Explanation:

• yes (correct)
• no (wrong)

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?

Explanation:

• yes (wrong)
• no (correct)

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

Explanation:

• Master outer (correct)
• Detail Outer (wrong)
• Normal
• Equi

Can you use sorted input if source data is data driven?

Explanation:

• yes (wrong)
• no (correct)

To configurehow the Integration Service applies the transformation logic to incoming data, which one  you can choose  of the following values

Explanation:

• Row (wrong)
• Transaction (wrong)
• All Input (wrong)
• you can choose any one of these

Can you use sorted input if the session uses incremental aggregation?

Explanation:

• yes (wrong)
• no (correct)

Can you use sorted input if aggregate expression contains nested aggregate functions?

Explanation:

• yes (wrong)
• no (correct)

Whitch guidelines are needful  to optimize the performance of an Aggregator transformation?

Explanation:

• Use sorted input to decrease the use of aggregate caches. (correct)
• Limit connected input/output or output ports. (correct)
• Filter before aggregating (correct)
• Non of these

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

Explanation:

• null (wrong)
• flase
• 0 (correct)
• non of these

Which one is the correct format of ADD_TO_DATE function?

Explanation:

• ADD_TO_DATE( ORDER_DATE, 1, 'MM' )
• ADD_TO_DATE( ORDER_DATE, 'MM', 1 ) (correct)
• ADD_TO_DATE(1, ORDER_DATE, 'MM' )
• ADD_TO_DATE(1,MM, ORDER_DATE )

Can we perform calulation in Look up?

Explanation:

• yes (correct)
• no (wrong)

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

Explanation:

• Master outer
• Detail Outer
• Full Outer (correct)
• left Outer

Which are the true statement to improve session performance in joiner ?

Explanation:

• Add transformations (correct)
• Configure the sort order (correct)
• Configure the Joiner transformation (correct)
• Do not user master outer join

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

Explanation:

• Master Outer (wrong)
• Detail Outer (correct)
• Notmal
• Equi

To maximize session performance what are the tips for filter transformation?

Explanation:

• Use the Filter transformation early in the mapping (correct)
• Use the Source Qualifier transformation to filter (correct)
• Use the Expression Qualifier transformation to filter (wrong)
• All of these (wrong)

Is Filter is case-sensitive?

Explanation:

• yes (correct)
• no (wrong)

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?

Explanation:

• yes (wrong)
• no (correct)

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

Explanation:

• Master outer (correct)
• Detail Outer (wrong)
• Normal
• Equi

Can you use sorted input if source data is data driven?

Explanation:

• yes (wrong)
• no (correct)

To configurehow the Integration Service applies the transformation logic to incoming data, which one  you can choose  of the following values

Explanation:

• Row (wrong)
• Transaction (wrong)
• All Input (wrong)
• you can choose any one of these

Can you use sorted input if the session uses incremental aggregation?

Explanation:

• yes (wrong)
• no (correct)

Can you use sorted input if aggregate expression contains nested aggregate functions?

Explanation:

• yes (wrong)
• no (correct)

Whitch guidelines are needful  to optimize the performance of an Aggregator transformation?

Explanation:

• Use sorted input to decrease the use of aggregate caches. (correct)
• Limit connected input/output or output ports. (correct)
• Filter before aggregating (correct)
• Non of these

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

Explanation:

• null (wrong)
• flase
• 0 (correct)
• non of these

Which one is the correct format of ADD_TO_DATE function?

Explanation:

• ADD_TO_DATE( ORDER_DATE, 1, 'MM' )
• ADD_TO_DATE( ORDER_DATE, 'MM', 1 ) (correct)
• ADD_TO_DATE(1, ORDER_DATE, 'MM' )
• ADD_TO_DATE(1,MM, ORDER_DATE )

Can we perform calulation in Look up?

Explanation:

• yes (correct)
• no (wrong)

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

Explanation:

• Master outer
• Detail Outer
• Full Outer (correct)
• left Outer

Which are the true statement to improve session performance in joiner ?

Explanation:

• Add transformations (correct)
• Configure the sort order (correct)
• Configure the Joiner transformation (correct)
• Do not user master outer join

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

Explanation:

• Master Outer (wrong)
• Detail Outer (correct)
• Notmal
• Equi

To maximize session performance what are the tips for filter transformation?

Explanation:

• Use the Filter transformation early in the mapping (correct)
• Use the Source Qualifier transformation to filter (correct)
• Use the Expression Qualifier transformation to filter (wrong)
• All of these (wrong)

Is Filter is case-sensitive?

Explanation:

• yes (correct)
• yes (correct)
• no (wrong)

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?

Explanation:

• yes (wrong)
• no (correct)

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

Explanation:

• Master outer (correct)
• Detail Outer (wrong)
• Normal
• Equi

Can you use sorted input if source data is data driven?

Explanation:

• yes (wrong)
• no (correct)

To configurehow the Integration Service applies the transformation logic to incoming data, which one  you can choose  of the following values

Explanation:

• Row (wrong)
• Transaction (wrong)
• All Input (wrong)
• you can choose any one of these

Can you use sorted input if the session uses incremental aggregation?

Explanation:

• yes (wrong)
• no (correct)

Can you use sorted input if aggregate expression contains nested aggregate functions?

Explanation:

• yes (wrong)
• no (correct)

Whitch guidelines are needful  to optimize the performance of an Aggregator transformation?

Explanation:

• Use sorted input to decrease the use of aggregate caches. (correct)
• Limit connected input/output or output ports. (correct)
• Filter before aggregating (correct)
• Non of these

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

Explanation:

• null (wrong)
• flase
• 0 (correct)
• non of these

Which repository  objects is not  created in Workflow Manager ?

Explanation:

• Database connections (wrong)
• Worklet
• Maplet (correct)
• Session

Which repository objects are created by repository manager?

Explanation:

• Folder (wrong)
• Users
• User groups (wrong)
• User type

Which statement is true?

Explanation:

• A repository domain consists of no of global repository and any number of local repositories (wrong)
• A repository domain consists of a single global repository and any number of local repositories (correct)
• A repository domain consists of a single global repository and any number of local repositories (correct)
• A repository domain consists of no of global repository and one local repositories
• non of these

Which is not a  versions of objects in the repository?

Explanation:

• Check out and check in versioned objects
• Compare objects (wrong)
• Track changes to an object
• Update a version (correct)

Where you can release lock if one object is locked?

Explanation:

• Work flow manager
• Designer
• Repository Manager (correct)
• Non of these

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

Explanation:

• date difference in number (wrong)
• date difference in no of day
• -1 (correct)
• 1

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

Explanation:

• no of days in number
• no of days in days (wrong)
• 1 (correct)
• 0

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

Explanation:

• 1
• -1
• 0 (correct)
• null

INSTR( "I am a informatica Developer', 'a', 1, 2 ) What is out put?

Explanation:

• 3 (wrong)
• 4
• 5
• 6 (correct)

INSTR( "informatica', 'a', -1, 2 ) What is out put?

Explanation:

• 5 (correct)
• 7
• 12
• 1

What will out put? SUBSTR( "Informatica",1,INSTR( "Informatica",1,1 ))

Explanation:

• I (wrong)
• atica
• tica
• Informa (correct)

LEAST( 12, 13, 21 ) what will output?

Explanation:

• 46
• 25
• 12 (correct)
• 21

LPAD( 190, 5, '0') What will output?

Explanation:

• 00000190 (wrong)
• 19000000
• 00190 (correct)
• 19000

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

Explanation:

• *..*.Informatica (correct)
• Informatica*..*.

LPAD( "Inform", -10, '*') What will out put?

Explanation:

• Inform***** (wrong)
• *****Inform (wrong)
• Inform
• null (correct)

Which repository  objects is not  created in Workflow Manager ?

Explanation:

• Database connections (wrong)
• Worklet
• Maplet (correct)
• Session

Which repository objects are created by repository manager?

Explanation:

• Folder (wrong)
• Users
• User groups (wrong)
• User type

Which statement is true?

Explanation:

• A repository domain consists of no of global repository and any number of local repositories (wrong)
• A repository domain consists of a single global repository and any number of local repositories (correct)
• A repository domain consists of no of global repository and one local repositories
• non of these

Which is not a  versions of objects in the repository?

Explanation:

• Check out and check in versioned objects
• Compare objects (wrong)
• Track changes to an object
• Update a version (correct)

Where you can release lock if one object is locked?

Explanation:

• Work flow manager
• Designer
• Repository Manager (correct)
• Non of these

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

Explanation:

• date difference in number (wrong)
• date difference in no of day
• -1 (correct)
• 1

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

Explanation:

• no of days in number
• no of days in days (wrong)
• 1 (correct)
• 0

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

Explanation:

• 1
• -1
• 0 (correct)
• null

INSTR( "I am a informatica Developer', 'a', 1, 2 ) What is out put?

Explanation:

• 3 (wrong)
• 4
• 5
• 6 (correct)

INSTR( "informatica', 'a', -1, 2 ) What is out put?

Explanation:

• 5 (correct)
• 7
• 12
• 1

What will out put? SUBSTR( "Informatica",1,INSTR( "Informatica",1,1 ))

Explanation:

• I (wrong)
• atica
• tica
• Informa (correct)

LEAST( 12, 13, 21 ) what will output?

Explanation:

• 46
• 25
• 12 (correct)
• 21

LPAD( 190, 5, '0') What will output?

Explanation:

• 00000190 (wrong)
• 19000000
• 00190 (correct)
• 19000

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

Explanation:

• *..*.Informatica (correct)
• Informatica*..*.
• Informatica*..*

LPAD( "Inform", -10, '*') What will out put?

Explanation:

• Inform***** (wrong)
• *****Inform (wrong)
• Inform
• null (correct)

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

Explanation:

• 80
• 8
• 10
• null (correct)

What is the return value of     'alpha' || NULL ?

Explanation:

• alphanull (wrong)
• null
• alpha (correct)
• false

Which variable sets the current value of a mapping variable to a value you specifyand returns the specified value?

Explanation:

• SETVARIABLE (correct)
• Function Syntax Description SETCOUNTVARIABLE (wrong)
• NON OF THESE

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

Explanation:

• SETMINVARIABLE
• SETVARIABLE
• SETCOUNTVARIABLE (correct)

• NON OF THESE

Which one is not an option in update-strategy?

Explanation:

• Truncate table (wrong)
• Update as Insert
• Update as Update
• Update as Delete (correct)

What is the meaning of  Update as Update?

Explanation:

• Update each row flagged for update if it is not exists in the target table.
• Update each row flagged for update if it exists in the target table. (correct)
• Update each row flagged for update if it is new in the target table.
• Non of these

What is meaning of  Update as Insert in update-strategy?

Explanation:

• Update each row flagged for update if it exists in the target table. (wrong)
• Inset each row flagged for update. (correct)
• Update the row if it exists. Otherwise, insert it.
• Non of these

What is meaning of  Update as  update else Insertin update-strategy?

Explanation:

• Update each row flagged for update if it exists in the target table (wrong)
• Inset each row flagged for update
• Update the row if it exists. Otherwise, insert it (correct)
• All of these

Which function Causes the Integration Service to skip a record and issue the specified error message?

Explanation:

• ERROR (correct)
• ABORT
• SKIP
• ERR

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

Explanation:

• 112
• .567
• 112.568 (correct)
• 112.6

What is Trunkcate Table option in update-strategy?

Explanation:

• truncate the target table before loading data. (correct)
• load the table value to another table
• delete the data of target which can roll back (wrong)
• non of these

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

Explanation:

• [InformaticaScenarios]
• "[InformaticaScenarios]"
• "[Informatica[Scenarios"]"
• InformaticaScenarios (correct)

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

Explanation:

• true
• false
• RAM (correct)
• MAR

ROUND( 10567.90, -2 ). What is the oot put of this ststement?

Explanation:

• 10567
• 567.90
• 10500 (correct)
• .90 (wrong)

Which version of informatica upports data integration for the cloud?

Explanation:

• 8.1
• 8.2
• 9 (correct)
• 7.0

Can we use sorted input option for incremental aggregation?

Explanation:

• yes (correct)
• no (wrong)

How can you handle multiple matches in lookup transformation?

Explanation:

• By Using "Lookup Match" option (wrong)
• By Using "Lookup Policy " option
• By Using " Multiple Match" option
• By Using "Lookup Policy on Multiple Match" option (correct)

What are the processes for creating indeses after loading processes completed?

Explanation:

• By using session level command task (correct)
• By Scripting for creating index (correct)
• By store procedure (wrong)
• All of these (wrong)

Which transformation receives input values from the result of a :LKP expression

in another transformation?

Explanation:

• Custom
• Connected SP
• Unconnected Look-up (correct)
• non of these

How to create a custom join in Source Qualifier transformation?

Explanation: When there is no PM key FK relation ship between two table, we can specify custom join by using user defined join in properties tab of source qualifier.

• By using custom-defined join (wrong)
• By using user-defined join (correct)
• non of these

IIF( Avg(salary) 20000,1,0)

Can I se this statement in aggrigator transformation?

Explanation:

• yes (correct)
• no (wrong)

Can we use the maping parameter or variable created in one maping into

other reusable transformation?

Explanation:

• yes (correct)
• no (wrong)

What is nested aggregate function?

Explanation:

• Takes only one output row (wrong)
• Returns only multiple output row (wrong)
• Returns only one output row (correct)
• Takes multiple output row

Which transformations are both connected and on connected?

Explanation:

• StoredProcedure (correct)
• SQL (omitted)
• Lookup (correct)
• ExternalProcedure (correct)
• ExternalProcedure

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

Explanation:

• through pmcmd task (wrong)
• through ftp (correct)
• ip address (correct)
• vpn service (correct)

What is single level aggregate function?

Explanation:

• Returns more than one row (correct)
• Returns only one row (wrong)
• Take input more than one row
• Take input one row (wrong)

Which of these are true?

Explanation:

• Drill-down allows the users view lower level (correct)
• drill-up allows the users to view higher level (correct)
• drill-up allows the users to view lower level

Which is not a kinds of lock on repository objects?

Explanation:

• Execute lock (wrong)
• Fetch lock
• Save lock
• Read lock
• Delete Lock (correct)

Which is not true of Cube?

Explanation:

• multidimensional representation of data
• used for analysis purpose
• multiple level of es-traction of data (correct)
• multiple views of data

What will happen if informatica server doesn't find session parameter and variable?

Explanation:

• Work flow will fail (correct)
• Automatically it will created
• Give a message to user to put it
• non of these

Which of these are limitationof bulk loading  of target load  type in Session?

Explanation:

• Less no of record (omitted)
• Use only Relational Database (wrong)
• Doesn't support flat file. (wrong)
• All of these (correct)

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

Explanation:

• Not a problem
• Only first row
• Only Last Row (correct)
• Non of these

How many transformation you can use in your mapping?

Explanation:

• 16
• Any number according to requirement (correct)
• In Informatica 7 limited in 8 unlimited

Which transformation  acts like CASE.. WHEN in Sql?

Explanation:

• filter
• router (correct)
• aggrigator
• look up

Which system is normalized?

Explanation:

• OLTP (correct)
• OLAP

Data mart is

Explanation:

• Data marts are optimized for INSERT, UPDATE operations (wrong)
• Data marts are generally designed for different single subject area (wrong)
• Non of these

Snow flake schema

Explanation:

• pointing to Dimensional tables itself are pointed by sub Fact tables. (wrong)
• pointing to fact tables itself are pointed by sub dimension tables.
• pointing to Datamart itself are pointed by sub dimension tables. (wrong)
• All of these

What is Trunkcate Table option in update-strategy?

Explanation:

• truncate the target table before loading data. (correct)
• load the table value to another table
• delete the data of target which can roll back
• non of these

Which of these is not a ETL tools in the Market?

Explanation:

• Decision
• DataStage (wrong)
• Stream
• Beacon (correct)

Which of these is not a reporting tool?

Explanation:

• DTS (correct)
• Analysis service
• Essbase
• BO