## Sequence Generator Transformation in Informatica - Shikshaglobe

Content Creator:

What is Sequence Generator Transformation?

Grouping generator change is inactive so it doesn't influence the number of info lines. The grouping generator is utilized to create essential key qualities and it's utilized to produce numeric succession values like 1, 2, 3, 4, 5, and so forth.

For instance, you need to dole out arrangement values to the source records, then, at that point, you can utilize the succession generator. The created succession values can be like 5, 10, 15, 20, 25, and so forth, or 10, 20, 30, 40, 50, and so on. contingent on the designed properties of the change.

To produce the succession numbers, we generally utilize the NEXTVAL segment.

Properties of Sequence Generator Transformation

Begin Value - It is the primary worth that will be produced by the change, the default esteem is 0.

Increase by - This is the number by which you need to augment the qualities. The default esteem is 1.

End esteem - It is the most extreme worth that the change ought to create.

Cycle - on the off chance that this choice is set, subsequent to arriving at the finish of the worth, the change restarts from the very outset esteem.

In this model, we will produce succession numbers and store in the objective.

Sequence Generator Transformation in Informatica plays a pivotal role. It is a powerful tool for generating sequential values and assigning them to data rows systematically. In this article, we'll delve into the significance, functionality, and practical applications of the Sequence Generator Transformation in Informatica.

Understanding the Sequence Generator Transformation

What is the Sequence Generator Transformation?

The Sequence Generator Transformation in Informatica is designed to generate unique sequential values. These values are typically used as surrogate keys, identifiers, or for any purpose where a sequential order is required. It can generate values in ascending or descending order and has a range of customizable properties.

Key Functions of Sequence Generator Transformation

The Sequence Generator Transformation offers several key functions:

• Sequential Value Generation: It generates sequential values starting from a specified initial value and incrementing by a defined step value.
• Resetting Sequences: You can reset the sequence at predefined intervals, allowing for the creation of sequences with periodic restarts.
• Customization: The transformation provides customization options for defining the range, increment value, and restart conditions for the generated sequences.

Configuration and Usage

Configuration Steps

To configure the Sequence Generator Transformation effectively, follow these steps:

1.     Create Output Ports: Define output ports in the Sequence Generator Transformation. These ports will hold the generated sequential values.

2.     Configure Properties: Specify the properties for the sequence, including the starting value, step value, minimum and maximum values, and reset conditions.

Practical Applications

The Sequence Generator Transformation is versatile and finds applications in various scenarios:

• Surrogate Key Generation: It is commonly used to generate surrogate keys for data warehousing purposes. These keys uniquely identify rows in a data warehouse.
• Order Numbering: In scenarios like order processing, it can generate sequential order numbers to ensure orders are processed in the desired sequence.
• Batch Processing: When dealing with data in batches, the Sequence Generator Transformation can be used to assign batch IDs sequentially.

Performance Considerations

Efficiency is crucial when working with the Sequence Generator Transformation:

• Step Value: Be mindful of the step value, as it can significantly impact the performance and the size of generated sequences.
• Initial Value: Carefully set the initial value to ensure that sequences do not overlap or start from incorrect values.
• Restart Conditions: When using sequence restart conditions, verify that they are set correctly to avoid unintended sequence resets.

Stage 1 - Create an objective table with the accompanying content.

Stage 2-Import the table in Informatica as target table

Stage 3 - Create another planning and import EMP source and EMP_SEQUENCE target table

Arrangement Transformation in Informatica with EXAMPLE

Stage 4 - Create another change in the planning

Select grouping change as the kind

Enter change name "seq_emp"

Select Create choice

Grouping Transformation in Informatica with EXAMPLE

Stage 5 - Sequence generator change will be made, select the done choice

Arrangement Transformation in Informatica with EXAMPLE

Stage 6 - Link the NEXTVAL segment of grouping generator to SNO section in target

Arrangement Transformation in Informatica with EXAMPLE

#### Take the next step

Stage 7 - interface different sections from source qualifier change to the objective table

Grouping Transformation in Informatica with EXAMPLE

Stage 8 - Double snap on the grouping generator to open property window, and afterward

Select the properties tab

Enter the properties with Start esteem =1, and leave the rest properties as default

Select OK button

Grouping Transformation in Informatica with EXAMPLE

Presently save the planning and execute it in the wake of making the meeting and work process.

The snow section in the objective would contain the succession numbers produced by the arrangement generator change.

In our model, the groupings will be like 1 - Scott, 2 - King, 3 - Adam, 4 - Miller, and so forth.

### Mahatma Gandhi University

Location: Soreng ,Sikkim , India
Approved: UGC
Course Offered: UG and PG

### MATS University

Location: Raipur, Chhattisgarh, India
Approved: UGC
Course Offered: UG and PG

### Kalinga University

Location: Raipur, Chhattisgarh,India
Approved: UGC
Course Offered: UG and PG

### Vinayaka Missions Sikkim University

Location: Gangtok, Sikkim, India
Approved: UGC
Course Offered: UG and PG

### Sabarmati University

Approved: UGC
Course Offered: UG and PG

### Arni University

Approved: UGC
Course Offered: UG and PG

### Capital University

Location: Jhumri Telaiya Jharkhand,India
Approved: UGC
Course Offered: UG and PG

### Glocal University

Location: Saharanpur, UP, India.
Approved: UGC
Course Offered: UG and PG

### Himalayan Garhwal University

Location: PG, Uttarakhand, India
Approved: UGC
Course Offered: UG and PG

### Sikkim Professional University

Location: Sikkim, India
Approved: UGC
Course Offered: UG and PG

### North East Frontier Technical University

Location: Aalo, AP ,India
Approved: UGC
Course Offered: UG and PG