Alien head

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

  1. Repository server admin console

  2. PMCMD command

  3. Repository manager

  4. PMREP command

Correct Option: B

Informatica Repository server is identified by

  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

Which of the following cannot be created inside workflow

  1. Mapping

  2. Session task

  3. Command task

  4. Email task

Correct Option: A

Which of the following is not client to Repository server?

  1. Mapping Designer

  2. Informatica server

  3. PMREP command

  4. Repository agent

Correct Option: D

Which of the following is not possible using Repository Manager

  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?

  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

Informatica Repository contains.

  1. Metadata for transformation

  2. Source schema

  3. Target schema

  4. All the Above

Correct Option: A

Which of the following transformations should be next to source transformation for flat file in the mapping?

  1. Expression transformation

  2. Source qualifier

  3. Target transformation

  4. None of the above

Correct Option: B
+ View questions