Tag: etl

Questions Related to etl

ETL Means

etl
  1. Extraction,transformation and loading

  2. Extract transactions and load

  3. Enable transactions and load

  4. All the above


Correct Option: B

Which of the following is Informatica PowerCenter Client Tools

etl
  1. Designer

  2. Workflow Manager,Metadata Reporter

  3. Repository Manager

  4. All the above


Correct Option: D
etl
  1. Repository server admin console

  2. PMCMD command

  3. Repository manager

  4. PMREP command


Correct Option: B
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
etl
  1. Mapping

  2. Session task

  3. Command task

  4. Email task


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.

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

etl
  1. session can be configured to run on demand

  2. All of the above


Correct Option: B
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