Informatica Quiz

Description: Informatica Quiz
Number of Questions: 11
Created by:
Tags: informatica etl
Attempted 0/11 Correct 0 Score 0
  1. ETL

  2. Reporting

  3. Modeling

  4. None


Correct Option: A
  1. Mapping

  2. Mapplet

  3. Session

  4. Workflow


Correct Option: B
Explanation:

To answer this question, the user needs to have some basic knowledge of Informatica.

In Informatica, a reusable component is a type of component that can be used in multiple locations within the same project or across multiple projects.

Now, let's look at each option and determine which one is a reusable component:

A. Mapping: A mapping is a set of instructions that defines how data is transformed from source to target. While a mapping can be reused in the same project, it cannot be reused across multiple projects. Therefore, mapping is not a reusable component.

B. Mapplet: A mapplet is a reusable set of transformations that can be used in multiple mappings. Mapplets are designed for reuse and can be used across projects, making them a reusable component.

C. Session: A session is a set of instructions that defines how a mapping is run, including the connections, sources, targets, and transformations. While a session can be used in multiple mappings within the same project, it cannot be reused across multiple projects. Therefore, session is not a reusable component.

D. Workflow: A workflow is a set of instructions that defines how and when a session or a set of sessions is run. While a workflow can be used in multiple mappings within the same project, it cannot be reused across multiple projects. Therefore, workflow is not a reusable component.

Based on the above explanations, the correct answer is:

The Answer is: B. Mapplet

  1. Source qualifier

  2. source and target

  3. Filter

  4. None of the above


Correct Option: A
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
  1. stored procedure

  2. Filter

  3. sorter

  4. joiner


Correct Option: A
  1. You can create input groups

  2. You can rename the transformation

  3. You can edit or delete the output group

  4. You can delete port in ip group


Correct Option: C
Explanation:

To answer this question correctly, the user needs to know about the Union transformation in Informatica PowerCenter.

Let's go through each option and explain why it is true or false:

A. You can create input groups: This statement is true. In the Union transformation, you can create input groups to add multiple input pipelines into a single output pipeline. This allows you to combine data from different sources.

B. You can rename the transformation: This statement is true. You can rename the Union transformation to any valid name that reflects its functionality.

C. You can edit or delete the output group: This statement is false. You cannot edit or delete the output group of a Union transformation. Once an output group is created, you can only add ports to it, but you cannot modify or remove the group.

D. You can delete port in the input group: This statement is true. You can delete ports in the input group of a Union transformation by selecting the port to be deleted and pressing the delete key.

Therefore, the answer is:

The Answer is: C

  1. one

  2. two

  3. many sessions

  4. three


Correct Option: A
  1. Dynamic

  2. static

  3. dynamic,static

  4. Dynamic,Static,persistent


Correct Option: D

which of the following transformation is not using to connect more than one table

  1. joiner

  2. source qualifier

  3. lookup

  4. sorter


Correct Option: D

AI Explanation

To answer this question, you need to understand the different transformations used in connecting more than one table in a database or data integration process.

Let's go through each option to understand why it is correct or incorrect:

Option A) joiner - This option is correct because the joiner transformation is used to combine data from multiple tables based on a common key column.

Option B) source qualifier - This option is correct because the source qualifier transformation is used to define the properties of a relational source table, including the SQL query to retrieve data from the table.

Option C) lookup - This option is correct because the lookup transformation is used to retrieve data from a reference table based on a matching key column.

Option D) sorter - This option is incorrect because the sorter transformation is not used to connect more than one table. It is used to sort data based on one or more key columns.

The correct answer is D) sorter. This option is incorrect because the sorter transformation is not used to connect more than one table.

Therefore, the correct answer is D) sorter.

- Hide questions