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

AI Explanation

To answer this question, you need to understand the different tools and commands used in executing workflows.

Option A) Repository server admin console - This option is incorrect because the repository server admin console is used for managing and administering the repository server, but it is not used for executing workflows directly.

Option B) PMCMD command - This option is correct because the PMCMD command is a command-line tool used to start, stop, and monitor PowerCenter workflows. It allows you to execute workflows and manage their execution state.

Option C) Repository manager - This option is incorrect because the repository manager is used for managing and administering the PowerCenter repository, but it is not used for executing workflows directly.

Option D) PMREP command - This option is incorrect because the PMREP command is a command-line tool used for repository administration tasks, such as importing and exporting objects, but it is not used for executing workflows directly.

The correct answer is B) PMCMD command. This option is correct because it is the command-line tool used specifically for executing PowerCenter workflows.

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
Explanation:

A mapping is a set of instructions that tell Informatica how to extract, transform, and load data. It is a separate entity from a workflow, so it cannot be created inside a workflow.

A session task is a type of task that executes a command or script. It can be created inside a workflow to automate tasks such as sending emails or updating databases.

A command task is a type of task that executes a command or script. It can be created inside a workflow to automate tasks such as sending emails or updating databases.

An email task is a type of task that sends an email. It can be created inside a workflow to notify users of certain events or to send out reports.

Therefore, the answer is A: Mapping. This is because a mapping is a separate entity from a workflow, so it cannot be created inside a workflow.

The correct option is A. This option is correct because a mapping is a separate entity from a workflow, so it cannot be created inside a workflow.

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
Explanation:

Explanation: Repository Manager is a tool used for managing Artifactory repositories. Let's go through each option to understand why it is correct or incorrect:

Option A) Creating folder within repository - This option is possible using Repository Manager. You can create new folders within a repository or move existing folders around to organize your artifacts.

Option B) Creating users and assigning roles - This option is possible using Repository Manager. You can create new users and assign roles to them to manage access to your repositories.

Option C) Taking backup of Repository - This option is not possible using Repository Manager. Although you can configure backup settings for your Artifactory instance, the backup itself must be performed using a separate tool outside of Repository Manager.

Option D) Comparing folders - This option is possible using Repository Manager. You can compare any two folders within a repository to see the differences between them and identify any missing or extra artifacts.

Therefore, the correct answer is C) Taking backup of Repository. This option is not possible using Repository Manager.

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

AI Explanation

To answer this question, you need to understand the order of transformations in a mapping for a flat file.

Option A) Expression transformation - This option is incorrect because the expression transformation is typically used to perform calculations or manipulate data within a mapping, but it is not directly related to the source transformation for a flat file.

Option B) Source qualifier - This option is correct. The source qualifier transformation is used to define the properties of the source data, such as the source table, columns, and filters. It is typically the first transformation to be used after the source transformation for a flat file.

Option C) Target transformation - This option is incorrect because the target transformation is used to define the properties of the target data, such as the target table and columns. It is typically used after the source qualifier transformation.

Option D) None of the above - This option is incorrect because the correct answer is B) Source qualifier.

The correct answer is B) Source qualifier. This option is correct because the source qualifier transformation is used immediately after the source transformation for a flat file in a mapping.

- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions