Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(3 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Modify the values in a reusable Sequence Generator transformation
Solution
The Start Value, Current Value and End Value cannot be modified in a reusable Sequence Generator transformation instance in a mapping.

To modify these values do the following in the PowerCenter Designer:

  1. Open the reusable Sequence Generator transformation in the Transformation Developer.

  2. Click on the Properties tab.

  3. Change any of the values here.

Note

Changes made to a reusable Sequence Generator transformation applies to all mappings using this transformation. ​

More Information

All the values are grayed out once the transformation is made reusable.
You cannot override the reusable Sequence Generator transformation properties at the mapping level or at the session level.

This maintains the uniqueness of the values when multiple mappings and sessions use the same sequence generator.

Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:1/11/2016 9:13 PMID:20133
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)