0

Simple Informatica ETL Quiz

Description: Simple Informatica ETL Quiz
Number of Questions: 10
Created by:
Tags: informatica
Attempted 0/10 Correct 0 Score 0

Workflow can be executed using

etl
  1. Repository server admin console

  2. PMCMD command

  3. Repository manager

  4. PMREP command


Correct Option: B
etl
  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
etl
  1. Mapping

  2. Session task

  3. Command task

  4. Email task


Correct Option: A
etl
  1. Mapping Designer

  2. Informatica server

  3. PMREP command

  4. Repository agent


Correct Option: D
etl
  1. Creating folder within repository

  2. Creating users and assigning roles

  3. Taking backup of Repository

  4. Comparing folders


Correct Option: C

Which of the following is true?

etl
  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?

etl
  1. Filter Transformation

  2. Aggregator Transformation

  3. Stored procedure Transformation

  4. Expression Transformation


Correct Option: C
etl
  1. Only Heterogeneous source

  2. Only heterogeneous Target

  3. Heterogeneous source and target

  4. Only homogeneous source and target


Correct Option: C
etl
  1. Metadata for transformation

  2. Source schema

  3. Target schema

  4. All the Above


Correct Option: A
etl
  1. Expression transformation

  2. Source qualifier

  3. Target transformation

  4. None of the above


Correct Option: B
- Hide questions