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

Repository database query determine which mappings use an Update Strategy transformation
Answer

The following query returns all PowerCenter mappings with update strategy transformations using repository views:

SELECT DISTINCT(PARENT_MAPPING_NAME) AS MAPPING_NAME, SUBJECT_AREA AS FOLDER_NAME
FROM REP_ALL_MAPPINGS A, REP_WIDGET_INST B
WHERE  A.PARENT_MAPPING_ID = B.MAPPING_ID AND
       A.PARENT_SUBJECT_ID=B.SUBJECT_ID AND
       B.WIDGET_TYPE=4;


More Information

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

Reference

Attachments

Last Modified Date:3/9/2009 5:49 PMID:103867
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)