0
Alien head

Simple Informatica ETL Quiz

Description: Simple Informatica ETL Quiz
Number of Questions: 10
Created by:
Tags: informatica

Workflow can be executed using

etl
  1. Repository server admin console

  2. PMCMD command

  3. Repository manager

  4. PMREP command

Answer: 2

Informatica Repository server is identified by

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

Answer: 4

Which of the following cannot be created inside workflow

etl
  1. Mapping

  2. Session task

  3. Command task

  4. Email task

Answer: 1

Which of the following is not client to Repository server?

etl
  1. Mapping Designer

  2. Informatica server

  3. PMREP command

  4. Repository agent

Answer: 4

Which of the following is not possible using Repository Manager

etl
  1. Creating folder within repository

  2. Creating users and assigning roles

  3. Taking backup of Repository

  4. Comparing folders

Answer: 3

Which of the following is true?

etl
  1. session can be configured to run on demand

  2. All of the above

Answer: 2

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

Answer: 3

Informatica supports

etl
  1. Only Heterogeneous source

  2. Only heterogeneous Target

  3. Heterogeneous source and target

  4. Only homogeneous source and target

Answer: 3

Informatica Repository contains.

etl
  1. Metadata for transformation

  2. Source schema

  3. Target schema

  4. All the Above

Answer: 1

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

etl
  1. Expression transformation

  2. Source qualifier

  3. Target transformation

  4. None of the above

Answer: 2
+ View questions