Informatica Quiz

1. 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
• 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 ?

Explanation:

• No
• Yes

3. Which one is not a type of fact?

Explanation:

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

4. Which one is not a type of dimension ?

Explanation:

• Conformed dimension

• Rapidly changing dimension

• Junk dimension

• Degenerated dimension

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

• 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?

Explanation:

• 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?

• Explanation:
• It can be re-used across repositories
• I 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?

Explanation:

• dd_reject
• 4
• 2
• dd_delete

9. Can we update records without using update strategy?

Explanation:

• Yes

• No

10) How to select distinct records form Source Qualifier?

Explanation:

• Choose 'non duplicate' option

• Choose 'select distinct' option

• Choose 'Select non duplicate'

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

Explanation:

• Standalone Repository

• Local Repository

• User Defined

• Versioned Repository

• Manual Repository

12. Joiner does not support flat file.

Explanation:

• False

• True

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

Explanation:

• Lookup

• Store Procedure

• Expression

• None of these

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

Explanation:

• Aggregator

• Lookup

• Filter

• Expression

15. Which one is not an active transformation?

Explanation:

• Sequence generator

• Normalizer

• Sql

• Store Procedure

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

Explanation:

• 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?

Explanation:

• 3

• 2

• 1

• 0

18) Which one needs a common key to join?

Explanation:

• source qualifier

• joiner

• look up

19. Which one support heterogeneous join?

Explanation:

• source qualifier

• joiner

• look up

20. What is the use of target loader?

Explanation:

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

21. Which one is not tracing level?

Explanation:

• terse

• verbose

• initialization

• verbose initialization

• terse initialization

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

Explanation:

• Session log

• workflow log

• Error log

• Bad files

• cache files

23. Is Fact table is normalized?

Explanation:

• yes

• no

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

Explanation:

• 0

• 1

• 2

• 3

25. Which transformation only works on relational source?

Explanation:

• lookup

• Union

• joiner

• Sql

26. Which are both connected and unconnected?

Explanation:

• External Store Procedure

• Stored Procedure

• Lookup

• Advanced External Procedure Transformation

27) Can we generate alpha-numeric value in sequence generator?

Explanation:

• yes

• no

28. Which transformation is used by COBOL source?

Explanation:

• Advanced External Procedure Transformation

• Cobol Transformation

• Unstructured Data Transformation

• Normalizer

29. What is VSAM normalizer transformation?

Explanation:

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

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

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

• None of these

30. What is VSAM normalizer transformation?

Explanation:

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

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

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

• None of these

31) Which are lookup caches?

Explanation:

• Persistent cache

• Dynamic cache

• Pre-build lookup cache

• Shared Cache

• None of these

32. What are the different values returned by NewLookupRow port?

Explanation:

• 0,1,3

• 0,1,2

• 1,2,3

• 2,3,4

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

Explanation:

• 0

• 1

• 2

• 4

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

Explanation:

• strict

• Dynamic

• Cached

35. What is meaning of tracing level?

Explanation:

• Data store in cache

• Data store in database

• Data store in log file

• Data store in buffer

36. Which command has 60seconds time out period?

Explanation:

• stop

• abort

• kill session

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

Explanation:

• stop

• abort

• kill session

38. Which one contains input and output transformations?

Explanation:

• mapplet

• reusable transformation

• reusable mapping

39. Which one can test multiple conditions?

Explanation:

• decode

• else if

• if

• none of these

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

Explanation:

• degenerated

• scd

• junk

• confirmed

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

Explanation:

• FTP

• Loader

• MQ

• ERP

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

Explanation:

• Transformation developer

• Mapping designer

• Mapplet designer.

• target designer

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

Explanation:

• Run only on demand

• Run once

• Run in six-month

• Run every

• Customized repeat

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

Explanation:

• Informatica Repository

• Informatica Server

• Repository manager

• All of these

45) How to Generate the Metadata Reports in Informatica?

Explanation:

• From a browser on any workstation

• Form repository

• From Work flow manager
  
  

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

Explanation:

• File

• Relational

• ERP

• 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?

Explanation:

• Add one dummy port in two sources.

• Use Joiner transformation to join the sources using dummy port

• Use Union

• In expression trans assign '1' to each port

48) Can start and stop single session in concurrent batch?

Explanation:

• yes

• no

49) Can you copy the batches?

Explanation:

• yes

• no

50) What are the processes that informatica runs the session?

Explanation:

• DTM

• Server Manager Process

• Load Manager Process

Server Configuration Process

51. What is the default source option for update strategy?

Explanation:

• Update or Delete

• Update or Insert

• Insert or Update

• Date Driven

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

Explanation:

• Slowly Growing target

• Simple Pass through mapping

• Simple Pass through target

• None of These

53. What is default join of joiner?

Explanation:

• Full Outer

• Detail Outer

• Normal

• Master Outer

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

Explanation:

• Full Outer

• Master Outer

• Normal

• Detail Outer

55. What is the default join of Source Qualifier?

Explanation:

• Left Outer join

• Equi Join

• Inner-equi join

• Outer join

56. What are the types of batches?

Explanation:

• Concurrent

• Dependent

• Sequential

• Circular

57. What are the types of groups in Router transformation?

Explanation:

• User defined group

• Multiple Group

• Default Group

• Single Group

58. Which one of these create log files?

Explanation:

• process manager

• Informatica Server

• Load Manager

• Non of these

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

Explanation:

• true

• false

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

Explanation:

• Reusable transformations

• Source definitions

• mapplet

• Sessions and workflows

• Target definitions