Alien head

Informatica Quiz

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

Informatica Is?

  1. ETL

  2. Reporting

  3. Modeling

  4. None


Correct Option: A

Which one is reusable component in Informatica?

  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

etl
  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

etl
  1. Designer

  2. Workflow Manager,Metadata Reporter

  3. Repository Manager

  4. All the above


Correct Option: D

which of the following is unconnected transformation

  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

How many mappings can be assigned to a session

  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
+ View questions