Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

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

Feedback

HOW TO: Retrieve a list of Sequence Generator transformations in the repository using the repository views
Solution

The following query will return a list of the Sequence Generator transformation in a repository using the REP_WIDGET_ATTR view:

SELECT * FROM REP_WIDGET_ATTR WHERE WIDGET_TYPE = 7

Widget type 7is the ID for Sequence Generator transformations.

More Information
Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:8/2/2008 4:57 PMID:17250
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)