Informatica Quiz

Description: Informatica Quiz
Number of Questions: 11
Created by:
Tags: informatica etl
Attempted 0/11 Correct 0 Score 0
  1. ETL

  2. Reporting

  3. Modeling

  4. None

Correct Option: A
  1. Mapping

  2. Mapplet

  3. Session

  4. Workflow

Correct Option: B

which is the minimum transformation required in mpping

  1. Source qualifier

  2. source and target

  3. Filter

  4. None of the above

Correct Option: A

Which of the following transformation is not a Active transformation

  1. Aggregator

  2. Union

  3. Lookup

  4. Source Qualifier

Correct Option: C

ETL Means

  1. Extraction,transformation and loading

  2. Extract transactions and load

  3. Enable transactions and load

  4. All the above

Correct Option: B

Which of the following is Informatica PowerCenter Client Tools

  1. Designer

  2. Workflow Manager,Metadata Reporter

  3. Repository Manager

  4. All the above

Correct Option: D
  1. stored procedure

  2. Filter

  3. sorter

  4. joiner

Correct Option: A

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

Correct Option: C
  1. one

  2. two

  3. many sessions

  4. three

Correct Option: A

Which of the following cashes used in informatica

  1. Dynamic

  2. static

  3. dynamic,static

  4. Dynamic,Static,persistent

Correct Option: D

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

  1. joiner

  2. source qualifier

  3. lookup

  4. sorter

Correct Option: D
- Hide questions