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: Use a query to determine the Sequence Generator values in a PowerCenter repository
Problem Description

The Sequence Generator stores values in the repository.

Cause
Solution

The following is a query for current value of all Sequence Generator within a repository:

SELECT a.attr_value AS current_value , b.WIDGET_NAME AS Transformation_name
FROM rep_widget_attr a , REP_ALL_TRANSFORMS b
WHERE a.attr_id=4
AND a.widget_id IN (SELECT widget_id FROM REP_ALL_TRANSFORMS WHERE widget_type_name LIKE 'Sequence')
AND a.widget_id=b.widget_id

For a specific current value attribute of Sequence Generator, replace ' sequence_generator_transformation_name ' in the following query with transformation name:

SELECT a.attr_value AS current_value , b.WIDGET_NAME AS Transformation_name
FROM rep_widget_attr a , REP_ALL_TRANSFORMS b
WHERE a.attr_id=4
AND a.widget_id IN (SELECT widget_id FROM REP_ALL_TRANSFORMS WHERE widget_type_name LIKE 'Sequence')
AND a.widget_id=b.widget_id
AND b.widget_name LIKE ' sequence_generator_transformation_name '

For all or another attribute (other than current_value ) of Sequence Generator transformation, run the following query:

SELECT a.* , b.WIDGET_NAME AS Transformation_name
FROM rep_widget_attr a , REP_ALL_TRANSFORMS b
WHERE a.attr_id=4
AND a.widget_id IN (SELECT widget_id FROM REP_ALL_TRANSFORMS WHERE widget_type_name LIKE 'Sequence')
AND a.widget_id=b.widget_id

To include the version number:

SELECT a.attr_value AS current_value , b.WIDGET_NAME AS Transformation_name, a.VERSION_NUMBER
FROM rep_widget_attr a , REP_ALL_TRANSFORMS b
WHERE a.attr_id=4
AND a.widget_id IN (SELECT widget_id FROM REP_ALL_TRANSFORMS WHERE widget_type_name LIKE 'Sequence')
AND a.widget_id=b.widget_id
Order by a.VERSION_NUMBER DESC

More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 8.x; PowerCenter 9.x
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:2/7/2012 9:30 PMID:20948
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)