Informatica Certification Questions and Answers

1.  Which one is not correct about filter transformation?

• Act as a 'where' condition
• Can't passes multiple conditions
• Act like 'Case' in PL/SQL
• If one record does not match condition, the record is blocked

2. Can we calculate in aggregator ?

•  No
• Yes

3.  Which one is not a type of  fact?

• Semi-additive
• Additive
• Confirm fact
• Not additive

 4. Which one is not a type of dimension ?

• Conformed dimension
• Rapidly changing dimension
• Junk dimension
• Degenerated dimension

5. Which of these not correct about Code Page?

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

6. What is a mapplet?

• Combination of reusable transformation.
• Combination of reusable mapping
• Set of transformations and it allows us to reuse
• None of these

7. What does reusable transformation mean?

• It can be re-used across repositories
• It can only be used in mapplet.
• It can use in multiple mapping only once
• It can use in multiple mapping multiple times

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

• dd_reject
• 4
• 2
• dd_delete

9. Can we update records without using update strategy?

• Yes
• No

10. How to select distinct records form Source Qualifier?

• Choose 'non duplicate' option
• Choose 'select distinct' option
• Choose 'Select non duplicate' option

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

• Standalone Repository
• Local Repository
• User Defined
• Versioned Repository
• Manual Repository

​12. Joiner does not support flat file.

• False
• True

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

• Lookup
• Store Procedure
• Expression
• Non of these

14. NetSal= basic+hra. In which transformation we can achieve this?

• Aggregator
• Lookup
• Filter
• Expression

15. Which one is not an active transformation?

• Sequence generator
• Normalizer
• SQL
• Store Procedure
  

 16. A lookup transformation is used to look up data in
 

• Flat file
• Relational table
• View
• Synonyms
• 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?
 

• 3
• 2
• 1
• 0

18. Which one need a common key to join?
 

• source qualifier
• joiner
• look up

19. Which one support hetrogeneous join?
 

• source qualifier
• joiner
• look up

20. What is the use of target loader?
 

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