Tag: informatica
Questions Related to informatica
-
Mapping
-
Mapplet
-
Session
-
Workflow
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
-
Source qualifier
-
source and target
-
Filter
-
None of the above
-
Aggregator
-
Union
-
Lookup
-
Source Qualifier
which of the following is unconnected transformation
-
stored procedure
-
Filter
-
sorter
-
joiner
AI Explanation
To answer this question, we need to understand what each transformation does and determine which one is unconnected.
Option A) Stored Procedure - This option is correct because a stored procedure in data integration is an example of an unconnected transformation. An unconnected transformation is not directly connected to the data flow and is usually called from another transformation or mapping.
Option B) Filter - This option is incorrect. A filter transformation is a connected transformation that allows you to filter rows based on specified conditions.
Option C) Sorter - This option is incorrect. A sorter transformation is a connected transformation that sorts data based on specified criteria.
Option D) Joiner - This option is incorrect. A joiner transformation is a connected transformation that combines data from multiple sources based on a specified join condition.
The correct answer is A) Stored Procedure. This option is correct because a stored procedure is an example of an unconnected transformation.
-
You can create input groups
-
You can rename the transformation
-
You can edit or delete the output group
-
You can delete port in ip group
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
-
one
-
two
-
many sessions
-
three
-
Dynamic
-
static
-
dynamic,static
-
Dynamic,Static,persistent
which of the following transformation is not using to connect more than one table
-
joiner
-
source qualifier
-
lookup
-
sorter
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.