Back
0

Simple Informatica ETL Quiz

Description: Simple Informatica ETL Quiz
Number of Questions: 10
Created by:
Tags: informatica
Start the Quiz
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

Show answer
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

Show answer
Correct Option: D

Which of the following cannot be created inside workflow
etl

  1. Mapping

  2. Session task

  3. Command task

  4. Email task

Show answer
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

Show answer
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

Show answer
Correct Option: C

Which of the following is true?
etl

  1. session can be configured to run on demand

  2. All of the above

Show answer
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

Show answer
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

Show answer
Correct Option: C

Informatica Repository contains.
etl

  1. Metadata for transformation

  2. Source schema

  3. Target schema

  4. All the Above

Show answer
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

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 physics
550 Quizzes
11687 Questions
 history
1132 Quizzes
13047 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions