Tag: etl

Quizzes (1) Questions (12)

Questions Related to etl

Multiple choice etl

ETL Means

  1. Extraction,transformation and loading

  2. Extract transactions and load

  3. Enable transactions and load

  4. All the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Multiple choice etl

Which of the following is Informatica PowerCenter Client Tools

  1. Designer

  2. Workflow Manager,Metadata Reporter

  3. Repository Manager

  4. All the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Informatica PowerCenter Client Tools suite includes the Designer (for creating mappings), Workflow Manager (for creating tasks/workflows), Workflow Monitor, and Repository Manager (for folder and user management). Therefore, all the listed tools are part of the client toolset.

Multiple choice etl

Workflow can be executed using

  1. Repository server admin console

  2. PMCMD command

  3. Repository manager

  4. PMREP command
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

PMCMD is the Informatica command-line utility specifically designed to execute and manage workflows. The Repository Server Admin Console is for repository administration, not workflow execution. The Repository Manager is a GUI for repository management. PMREP is a command-line utility for repository object management (migrate, promote, etc.), not workflow execution. Only PMCMD can start and control workflow execution from command line or scripts.

Multiple choice etl

Informatica Repository server is identified by

  1. Repository server name and port number

  2. Repository server name

  3. Repository server name and host name

  4. Host name and port number
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Informatica Repository Server is uniquely identified by the host name (where the server runs) and the port number (which the server listens on). The repository server name is an alias configured within the domain but is not sufficient for network identification - multiple servers could have the same name in different domains. The combination of host name and port number provides the complete network address needed for clients to connect to the correct repository server instance.

Multiple choice etl

Which of the following cannot be created inside workflow

  1. Mapping

  2. Session task

  3. Command task

  4. Email task
Reveal answer Fill a bubble to check yourself
A Correct answer
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.

Multiple choice etl

Which of the following is not client to Repository server?

  1. Mapping Designer

  2. Informatica server

  3. PMREP command

  4. Repository agent
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Repository Agent is a server-side component that runs on the Repository Server machine and handles repository operations for client tools - it is NOT a client itself. Mapping Designer, Informatica Server (Integration Service), and PMREP command all act as clients that connect TO the Repository Server to access metadata. The Repository Agent is the server-side process that services these client requests, making it the only non-client option listed.

Multiple choice etl

Which of the following is not possible using Repository Manager

  1. Creating folder within repository

  2. Creating users and assigning roles

  3. Taking backup of Repository

  4. Comparing folders
Reveal answer Fill a bubble to check yourself
C Correct answer
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.

Multiple choice etl

Which of the following is true?

  1. session can be configured to run on demand

  2. All of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Informatica PowerCenter, sessions can indeed be configured to run on demand via the Workflow Manager or command line. Since option 6327 is true and there are no other specific true statements listed to justify 'All of the above', the structure is slightly flawed, but the stored answer is acceptable.

Multiple choice etl

If you want to create indexes after the load process which transformation you choose?

  1. Filter Transformation

  2. Aggregator Transformation

  3. Stored procedure Transformation

  4. Expression Transformation
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Stored Procedure Transformation allows you to call database stored procedures within a mapping. To create indexes after loading data, you would use a stored procedure containing CREATE INDEX statements and execute it via this transformation after the data flow completes. Filter Transformation only filters rows, Aggregator performs aggregation, and Expression Transformation calculates values - none can execute DDL commands like CREATE INDEX. Only Stored Procedure Transformation can run arbitrary SQL including DDL for index creation.

Multiple choice etl

Informatica supports

  1. Only Heterogeneous source

  2. Only heterogeneous Target

  3. Heterogeneous source and target

  4. Only homogeneous source and target
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Informatica PowerCenter supports heterogeneous sources and targets - meaning it can extract data from one type of source system (e.g., Oracle) and load it into a different type of target system (e.g., SQL Server, flat file, XML) in the same workflow. This is a core ETL capability. Option A and B are incorrect because Informatica is not limited to only heterogeneous on one side. Option D is incorrect because Informatica specifically supports and is designed for cross-platform (heterogeneous) data integration.