Tag: informatica

Questions Related to informatica

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