0
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

etl
  1. Repository server admin console

  2. PMCMD command

  3. Repository manager

  4. PMREP command


Correct Option: B

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


Correct Option: D

Which of the following cannot be created inside workflow

etl
  1. Mapping

  2. Session task

  3. Command task

  4. Email task


Correct Option: A

Which of the following is not client to Repository server?

etl
  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

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

Informatica supports

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

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

etl
  1. Expression transformation

  2. Source qualifier

  3. Target transformation

  4. None of the above


Correct Option: B
+ View questions