Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: Can the current value of the Sequence Generator be reset to the start value when copying a folder?
Problem Description
When copying a folder there is an option to "Retain persisted values" and "Retain current values for Sequence Generator". Is there an option to reset the current value to the start value in Sequence Generator transformations?
Cause
Solution
There is no option in to reset the sequence generator's current value to start value when copying a folder.

Workaround:

Use the Updateseqgenvals pmrep command to reset the current value after copying the folder.

More Information

The "Retain persisted values" option will retain the values for mapping variables and workflow variables.

The option "Retain current values for Sequence Generator" will appear in the "Copy folder" wizard when the folder is replaced. When this option is selected, the sequence generator values in the target folder will be retained. When it is not selected these values will be replaced with the ones from the source folder.

A feature request (CR 91924) has been created to add this option in a future release of PowerCenter.

Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter; PowerCenter 7
Database:
Operating System:
Other Software:

Reference

For more details on using the Updateseqgenvals pmrep command refer to the PowerCenter > "Using pmrep and pmrepagent">"pmrep Repository Commands"> "Updating Sequence Generator Transformations (Updateseqgenvals)"



Attachments
Last Modified Date:8/2/2008 7:17 PMID:16241
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)