Informatica 220
A quiz created by Swapnil and Ajay for practice of Informatica
- 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 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 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.
- 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
Back to top