Informatica 220

219 Questions | By Swapdeo | Updated: Mar 22, 2022 | Attempts: 2568

Questions

Settings

Create your own Quiz

A quiz created by Swapnil and Ajay for practice of Informatica

Questions and Answers

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.

How to select distinct records form Source Qualifier?
- 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