Simple Informatica ETL Quiz

Description: Simple Informatica ETL Quiz
Number of Questions: 10
Created by:
Tags: informatica
Attempted 0/10 Correct 0 Score 0
  1. Repository server admin console

  2. PMCMD command

  3. Repository manager

  4. PMREP command

Correct Option: B
  1. Repository server name and port number

  2. Repository server name

  3. Repository server name and host name

  4. Host name and port number

Correct Option: D
  1. Mapping

  2. Session task

  3. Command task

  4. Email task

Correct Option: A
  1. Mapping Designer

  2. Informatica server

  3. PMREP command

  4. Repository agent

Correct Option: D
  1. Creating folder within repository

  2. Creating users and assigning roles

  3. Taking backup of Repository

  4. Comparing folders

Correct Option: C
  1. session can be configured to run on demand

  2. All of the above

Correct Option: B

If you want to create indexes after the load process which transformation you choose?

  1. Filter Transformation

  2. Aggregator Transformation

  3. Stored procedure Transformation

  4. Expression Transformation

Correct Option: C

Informatica supports

  1. Only Heterogeneous source

  2. Only heterogeneous Target

  3. Heterogeneous source and target

  4. Only homogeneous source and target

Correct Option: C
  1. Metadata for transformation

  2. Source schema

  3. Target schema

  4. All the Above

Correct Option: A
  1. Expression transformation

  2. Source qualifier

  3. Target transformation

  4. None of the above

Correct Option: B
- Hide questions