Simple Informatica ETL Quiz Online Test

Development Tools
Crystal Report
Simple Informatica ETL Quiz

Back

Simple Informatica ETL Quiz

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

Start the Quiz

Attempted 0/10 Correct 0 Score 0

‹

›

Workflow can be executed using

etl

Repository server admin console
PMCMD command
Repository manager
PMREP command

Show answer

Correct Option: B

AI Explanation

AI 1

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.

Thanks
Wrong explanation

Informatica Repository server is identified by

etl

Repository server name and port number
Repository server name
Repository server name and host name
Host name and port number

Show answer

Correct Option: D

AI Explanation

AI 1

To answer this question, we need to understand how the Informatica Repository server is identified.

Option A) Repository server name and port number - This option is incorrect because the Repository server is not solely identified by its name and port number. These are just components of its identification.

Option B) Repository server name - This option is incorrect because the Repository server is not solely identified by its name. It requires additional information for identification.

Option C) Repository server name and host name - This option is incorrect because the Repository server is not solely identified by its name and host name. Again, additional information is needed for identification.

Option D) Host name and port number - This option is correct because the Informatica Repository server is identified by its host name and port number. These two pieces of information together uniquely identify the server.

Therefore, the correct answer is D) Host name and port number.

Thanks
Wrong explanation

Which of the following cannot be created inside workflow

etl

Mapping
Session task
Command task
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

Mapping Designer
Informatica server
PMREP command
Repository agent

Show answer

Correct Option: D

AI Explanation

AI 1

To answer this question, we need to understand the roles of each component in the Informatica PowerCenter architecture.

Option A) Mapping Designer - This option is incorrect because Mapping Designer is a client tool used to design and create mappings in PowerCenter. It connects to the Repository server to store and retrieve mapping metadata.

Option B) Informatica server - This option is incorrect because the Informatica server, also known as the Integration Service, is responsible for executing the workflows and tasks defined in the mappings. It connects to the Repository server to retrieve the necessary metadata and configuration information.

Option C) PMREP command - This option is incorrect because the PMREP command is a command-line utility provided by Informatica to manage and administer the Repository server. It can be used to perform various tasks like importing and exporting repository objects, creating backups, managing privileges, etc. It interacts with the Repository server to perform these operations.

Option D) Repository agent - This option is correct because there is no component called Repository agent in the Informatica PowerCenter architecture. The Repository server is responsible for managing and storing the metadata of all the PowerCenter objects. The Repository agent does not exist.

Therefore, the correct answer is D) Repository agent.

Thanks
Wrong explanation

Which of the following is not possible using Repository Manager

etl

Creating folder within repository
Creating users and assigning roles
Taking backup of Repository
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

session can be configured to run on demand
All of the above

Show answer

Correct Option: B

AI Explanation

AI 1

To answer this question, let's go through each option:

Option A) Session can be configured to run on demand - This option is correct because a session can indeed be configured to run on demand. This means that the session can be initiated or started whenever it is needed, rather than running continuously.

Option B) All of the above - This option is also correct because it includes Option A, which is true. Additionally, if there were any other options provided, this option would encompass them as well.

Therefore, the correct answer is B) All of the above. This option is correct because it includes the true statement from Option A and potentially other true statements if they were provided.