Alien head

Informatica Quiz

Description: Informatica Quiz
Number of Questions: 11
Created by:
Tags: informatica etl

Informatica Is?

  1. ETL

  2. Reporting

  3. Modeling

  4. None

Answer: 1

Which one is reusable component in Informatica?

  1. Mapping

  2. Mapplet

  3. Session

  4. Workflow

Answer: 2

which is the minimum transformation required in mpping

  1. Source qualifier

  2. source and target

  3. Filter

  4. None of the above

Answer: 1

Which of the following transformation is not a Active transformation

  1. Aggregator

  2. Union

  3. Lookup

  4. Source Qualifier

Answer: 3

ETL Means

etl
  1. Extraction,transformation and loading

  2. Extract transactions and load

  3. Enable transactions and load

  4. All the above

Answer: 2

Which of the following is Informatica PowerCenter Client Tools

etl
  1. Designer

  2. Workflow Manager,Metadata Reporter

  3. Repository Manager

  4. All the above

Answer: 4

which of the following is unconnected transformation

  1. stored procedure

  2. Filter

  3. sorter

  4. joiner

Answer: 1

which of the following statement about union transformation is False

  1. You can create input groups

  2. You can rename the transformation

  3. You can edit or delete the output group

  4. You can delete port in ip group

Answer: 3

How many mappings can be assigned to a session

  1. one

  2. two

  3. many sessions

  4. three

Answer: 1

Which of the following cashes used in informatica

  1. Dynamic

  2. static

  3. dynamic,static

  4. Dynamic,Static,persistent

Answer: 4

which of the following transformation is not using to connect more than one table

  1. joiner

  2. source qualifier

  3. lookup

  4. sorter

Answer: 4
+ View questions