Informatica

1 Which of the following are active Transformations?
(a) Sorter
(b) Expression
(c) Normalizer
(d) Filter
2. Which Function(s) cannot be used in Expression Widget(doubt)

(a) AVG
(b) COUNT
(c) LTRIM
(d) RTRIM
3.What manages the scheduling and execution of workflows?

(a) Informatica Server/Integeration services
(b) Repository Server
(C) Designer
(d) Monitor
4.Which component can be used for creating Repository?

(a) Repository Manager
(b) Designer
(c) Workflow Manager
(d) Administration Console
5. In Sequence Generator, If Current Value = 10, Increment By value=1, what is the

NextVal value?
(a) 9
(b) 10
(c) 11
(d) 12
6. Which of the following is/are better option if all below satisfies the
requirement
(a) Filter Transformation used near to Source Qualifier
(b) Filter Transformation used near to Target
(c) Filter Transformation used anywhere in the mapping
(d) Filter Transformation used after any active transformation
7.if the data does not change from session to session the cache use is
(a) persistant cache
(b) Static cache
(c) dynamic cache
(d) no chache
8. Joiner Can
(a) Join any two heterogeneous sources
(b) Join only Sources of same database
(c) Join only Flatfiles
(d) Join only Flatfile and database
9. Which of the following is/are true for Normalizer?

(a) Converts Rows into Columns
(b) Converts Columns into Rows
(c) Normalizer is active Transformation
(d) Normalizer is passive Transformation
10. In which Order does the execution of ports take place

(a) Input Port, Output Port, Variable Port
(b) Input Port, Variable Port, Output Port
(c) Output Port, Input Port, Variable Port
(d) Output Port, Variable Port, Input Port
11. Which Component gets metadata from Repository?

(a) Informatica Server
(b) Informatica Workflow Designer
(c) Informatica Designer
(d) Informatica Repository Server/service
12. How many port values can be retrieved by an unconnected lookup and connected
lookup respectively
(a) Zero, One
(b) One, Unlimited
(c) One, One
(d) Unlimited, Unlimited
13. For Unconnected Lookup how many ports can be given as input values
(a) Zero
(b) One
(c) Two
(d) Unlimited
20. For Updating Record on database table,

(a) We need Key on the Informatica target Metadata only
(b) We need key on the database only
(c) We need key on both Target Metadata and Database
(d) Keys are not requiredImage result for informatica mcq quiz
21. we want to compare objects in Filter and aggregate transformation which data
type you use��..
a) Integer
b)Double
c)String
d)Decimal
e) Char
22. Which of following Joins in Informatica��

A Master outer
B Full outer
C Left outer
D Outer join
23. What are tasks can do in designer �..

A Inport / Export registry
B Inport / Export repository objects
C Create mapping
D Creating mapplet
24. Types of Lookup cache��.

A Dynamic Cache
B Volatile Cache
C Non volatile Cache
D Re Cache from DB
E Static Cache
25.17 Performance of Aggregate, Look up transform improved by sorter and cache

A True
B False
26. which one of these non-reusable transformation��.
A ERP
B Seq Generator Transform
C Look up Transform
D Dynamic lookup cache
27. Which of following is Passive Transformation��

A Router
B Rank
C Source Qualifier
D Aggregate
E S�quence generator
28.Log initialisation, Error message and Notification of related data.

A terse
B Normal
C Verbose init
D Verbose Data
29. Which of the following is Active

A Aggregator
B Lookup
C Expression
D Router
30 Command,Session,e-mail are Reusable tasks.
A True
B False
31 Cobol source used by ��. Transformation.

A Normalizattion
B Erp Source Qualifier
C Source Qualifier
D XML Source Qualifier
34 Purpose of SQL override Used to write user defined SQL statements in

A source qualifier
B look up transformations
C Target In mapping
D Normalizer
35 Lookup policy on multiple match

A Use first value
B Use Last value
c Report Error
D Use any Value
36 Types of Caches in Lookup.

a static,
b recache,
c persistant,
d shared
37 Folder Security option in informatica repository

a) Read
b) write
c) Overwrite
d) Append
e) Execute
38 default join between tables

A) normal join
B) Inner join
C) Master Outer
D) Detail outer
39 performance can be imp by sorted input in which transformation
A) aggregator
B) Lookup
C) Normalizer
D) Expression
40 source table does not having which ports?

A) i/p ports
B) o/p ports
C) variable port
D) meta data extension
41. Number of log files by default in Infa?

A) 1
B) 2
C) 3
D) 4
42 Which transformation helps to convert the rows into columns?

A) Rank Transformation
B) Sorter Transformation
C) Normalizer Transformation
D) Update Strategy
43 User, Groups, Privileges are created in which client tool?

A) Repository manager
B) Workflow Manager
C) Workflow monitor
D) Designer
44. To determine which column caused the row to be rejected, what does the server
add to give more info about columns?
a) Key indicators
b) Key breaks
c) Row indicator and column indicators
d) Variable indicator
45 which is reusable component in informatica

A) Workflow
B) Mapplet
C) Session
D) Mapping
46 The list of different tasks where source qualifier is used is as follows:
A) Rows filtering
B) Data sorting
C) Custom query creation
D) Joining tables from the same source
47 How to select distinct records form Source Qualifier?
A) Choose 'select distinct' option
B) Choose 'non duplicate' option
C) Choose 'Select non duplicate
48 What type of data sources are supported in the Source Type Lookup transformation
property?
A Database
B Database and flat file
C Database, flat file and COBOL file
D Database, flat file, COBOL file, and XML file
49 Can we update records without using update strategy?

A Yes
B No
50 Which one is not an option in update strategy?

A dd_reject
B 4
C 2
D dd_delete
51 How to execute PL/SQL script from Informatica mapping?

A Lookup
B Store Procdure
C Expression
D Non of these
52 NetSal= bassic+hra. In which transformation we can achive this?

A Aggrigator
B Lookup
C Filter
D Expression
53 Which one is not a type of dimension ?

A Conformed dimension
B Rapidly changing dimension
C Junk dimension
D Degenerated dimension
54 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 Non of the above
55. Type of loads in in ETL

A Full load
B Incremental load
c Partial load
D No load
56 Which of the following is the default Transaction Control transformation

variable value?
A. TC_COMMIT_BEFORE
B. TC_COMMIT_AFTER
C. TC_CONTINUE_TRANSACTION
D. TC_ROLLBACK_BEFORE
57 Which one of the following transformations may be unconnected in a valid

mapping?(choose one)
A. Lookup
B. Lookup and Source Qualifier
C. Lookup and Transaction Control
D. Lookup, Source Qualifier, or Transaction Control
58 In which of the following selections are all of the transformations active?

A. Expression, Router, Joiner
B. Update Strategy, Expression, Aggregator
C. Stored Procedure, Joiner, Router
D. Router, Update Strategy, Joiner
59 Following filter condition used in filter IIF(ISNULL(FIRST_NAME), TRUE,FALSE).

If All the rows having NULL as FIRST_NAME��..?
A. This will give error at run time and the record will be logged in the session
log file
B. Will bw discarded
C. The condition is invalid
D. Will be passed to the next transformation
60 In the TO_CHAR (date) function, what do the format strings D,DD, and DDD
produce?
A. Character day of week, character day of month, and character day of year
respectively
B. Day of week, day of month, and Julian date since 4713 B.C. 00:00:00 (midnight)
respectively
C. Each produces numerical day of week
D. Numerical day of week, day of month, and day of year respectively
61 Why should the SETCOUNTVARIABLE function be used only once in a pipeline?

A. This may cause the SETCOUNTVARIABLE to set to the value 0.
B. This may cause inconsistent results when you use the same variable function
multiple times in a mapping
C. This may cause a runtime error in the session.
D. This may cause a runtime error in the workflow
62 what option are use set value to mapping variables

A setmaxvariable
B setminvariable
C setcountvariable
D setvariable
63 Which of the following transformations may be unconnected in a valid mapping?

A. Lookup, stored procedure, external procedure
B. Lookup, stored procedure, java
C. Java, lookup, transaction control
D. Transaction control, java, lookup
64 Which of the following type of sources are supported for source qualifier
transformation?
A. relational database & flat files
B. relational database & COBOL files
C. relational database & COBOL files & FLAT FILES
D. relational database ONLY
65 An Unconnected Stored Procedure can run in the following fashions?
A. From an expression
B. As a Post-Session SQL command
C. As a Pre-Session SQL command
D. As the only object In the mapping
66 Which of these statements is correct concerning a Lookup transformation's

persistent
cache?
A. A persistent cache is stored on disk, and must be named to make it useable in
multiple mappings
B. persistent cache is stored on disk, to refresh the cache the disk files must be
deleted manually
C. When the Integration Service cannot find the persistent cache file and the
recache property is not set, the session fails
D. A persistent cache can only be used by one mapping
67 What function could be used to exchange'i'with'I'in the COMPANY port given the
following
expression?
functionname{1, COMPANY, 'i','I')
A. CHOOSE
B. REPLACECHR
C. REG_REPLACE
D. INSTR
68 Which port types are applicable to the Stored Procedure transformation?(Choose

all that apply)
A. lnput
B. Output
C. Variable
D. Return
69 Which command line tool would you use to execute a workflow?

A. infasetup
B. infacmd
C. pmcmd
D. pmrep
Answer: C
70 Which of the following is a reusable task available in workflow manager?

A. Decision
B. Assignment
C. Control
D. Command
71 Two pipelines (A & B) are entering a Joiner transformation with each having a
record size
of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of
1,000,000
records. Which pipeline should be designated the master pipeline?
A. Pipeline A
B. Pipeline B
C. Both Pipelines should be cached for performance reasons
D. Pipeline B if and only if Pipeline A is sorted
Answer: A
72 Which value returned by NewLookupRow port says that Integration Service inserts
the row into the cache?
A 1
B 3
B 2
c 0
73. Which type of join join keeps all rows of data from the master source and the
matching rows from the detail source?
A Detail Outer
B Normal
c Equi
d Master Outer
74 How can you handle multiple matches in lookup transformation?
A By Using " Multiple Match" option

B By Using "Lookup Match" option
C By Using "Lookup Policy on Multiple Match" option
D By Using "Lookup Policy " option
75.Whe we viewing logfile wich colum header would you click to see all error
messages at top
process-id
messing
sevirity
message code
76 when session fails no logfile is created what should check next
a reject file
b workflow log
c data in target
D session run properties
77 how many pipeline joiner can join
A 1
B 2
C 3
D 4
78 can we use sqloverride in unconnected lookup

A True
B False
79 how the normalizer ports determined

A occur structure of input data
b occurs values of set in in normalizer tab
c number of ports created in normalizer
80 The reserved word dd_insert can be use to set row type with in wich
transfermation
A experssion, aggrigator, update statergy
b update startergy
c expression and update statergy
D update statergy and lookup
81

Informatica

Uploaded by

Copyright:

Available Formats

Informatica

Uploaded by

Document Information

Original Description:

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Informatica

Uploaded by

Copyright:

Available Formats

1 Which of the following are active Transformations?

2. Which Function(s) cannot be used in Expression Widget(doubt)

3.What manages the scheduling and execution of workflows?

4.Which component can be used for creating Repository?

5. In Sequence Generator, If Current Value = 10, Increment By value=1, what is the

9. Which of the following is/are true for Normalizer?

10. In which Order does the execution of ports take place

11. Which Component gets metadata from Repository?

20. For Updating Record on database table,

22. Which of following Joins in Informatica���

23. What are tasks can do in designer �..

24. Types of Lookup cache��.

25.17 Performance of Aggregate, Look up transform improved by sorter and cache

27. Which of following is Passive Transformation���

28.Log initialisation, Error message and Notification of related data.

29. Which of the following is Active

30 Command,Session,e-mail are Reusable tasks.

31 Cobol source used by ���. Transformation.

34 Purpose of SQL override Used to write user defined SQL statements in

35 Lookup policy on multiple match

36 Types of Caches in Lookup.

37 Folder Security option in informatica repository

38 default join between tables

39 performance can be imp by sorted input in which transformation

40 source table does not having which ports?

41. Number of log files by default in Infa?

42 Which transformation helps to convert the rows into columns?

43 User, Groups, Privileges are created in which client tool?

45 which is reusable component in informatica

46 The list of different tasks where source qualifier is used is as follows:

49 Can we update records without using update strategy?

50 Which one is not an option in update strategy?

51 How to execute PL/SQL script from Informatica mapping?

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

53 Which one is not a type of dimension ?

A Combination of reusable transformation.

55. Type of loads in in ETL

56 Which of the following is the default Transaction Control transformation

57 Which one of the following transformations may be unconnected in a valid

58 In which of the following selections are all of the transformations active?

59 Following filter condition used in filter IIF(ISNULL(FIRST_NAME), TRUE,FALSE).

61 Why should the SETCOUNTVARIABLE function be used only once in a pipeline?

62 what option are use set value to mapping variables

63 Which of the following transformations may be unconnected in a valid mapping?

66 Which of these statements is correct concerning a Lookup transformation's

68 Which port types are applicable to the Stored Procedure transformation?(Choose

69 Which command line tool would you use to execute a workflow?

70 Which of the following is a reusable task available in workflow manager?

74 How can you handle multiple matches in lookup transformation?

A By Using " Multiple Match" option

76 when session fails no logfile is created what should check next

77 how many pipeline joiner can join

78 can we use sqloverride in unconnected lookup

79 how the normalizer ports determined

You might also like

22. Which of following Joins in Informatica��

27. Which of following is Passive Transformation��

31 Cobol source used by ��. Transformation.