Is it possible to change the sequence generator properties

For each input row, sequence generator produces a single row. Hence it is a passive transformation. If you do not do this step you will end up to see the old value in seq edit. If you do not do so then you will end up with seeing the old current value which is wrong for next session in edit. Hi Vijay, You have mentioned "If you want the same sequence values to be generated for more than one target, then connect the sequence generator to an expression transformation and connect the expression transformation port to the targets.

Connect NEXTVAL port of sequence generator transformation to the expression trnsformation and connect this nextval port of expression transformation to the target s. Hi Vijay, If I want to generate unique values in two columns of the same target table,how it can be achieved using seq gen transformation? If you are generating unique values automatically, then a single column will be enough. You don't need two columns to maintain uniqueness.

With sequence generator transformation, it is not possible. You have to write your own logic for this. Post a Comment. Facebook Twitter. Sequence generator transformation is a passive and connected transformation. The sequence generator transformation is used for Generating unique primary key values. Replace missing primary keys Generate surrogate keys for dimension tables in SCDs. Cycle through a sequential range of numbers. Creating Sequence Generator Transformation : Follow the below steps to create a sequence generator transformation: Go to the mapping designer tab in power center designer.

Click on the transformation in the toolbar and then on create. Select the sequence generator transformation. If a transformation is optional and there are no incoming fields, the mapping. For example, you configure a parameter for the source connection. When you configure the mapping.

Disable incoming fields. Disable incoming fields to connect only the generated sequence to a downstream transformation. If you disable incoming fields, you must connect at least one field from another transformation to the downstream transformation. Sequence Generator transformation. Disabling incoming fields. Updated November 05, Download Guide. Send Feedback. Cloud Data Integration Homepage. Free Trial. Knowledge Base.

Success Portal. Back to Top. Back Next. Default is disabled. Default is 1. Maximum value is 2,,, Maximum value that the mapping task generates. If the sequence reaches this value during the task run and the sequence is not configured to cycle, the run fails.

Maximum value is 9,,,,,, In an elastic mapping , set the end value to at least the maximum number of rows that you process. The value you want the mapping task to use as the first value in the sequence. If you want to cycle through a series of values, the value must be greater than or equal to the Start Value and less than the End Value.

If enabled, the mapping task cycles through the sequence range. If disabled, the task stops the sequence at the configured End Value. Next Continue. Home Testing Expand child menu Expand. SAP Expand child menu Expand. Web Expand child menu Expand. Must Learn Expand child menu Expand. Big Data Expand child menu Expand.

Live Project Expand child menu Expand. AI Expand child menu Expand.