Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: What is the query to fetch the mapping which has Sorter transformation?
Solution
You can use the following query on the repository views to get the mapping which has sorter transformation:

SELECT c.subject_area folder_name,a.task_name workflow_name,b.instance_name session_name, c.mapping_name,
d.instance_name transformation_name
FROM REP_ALL_TASKS a,REP_TASK_INST b,REP_LOAD_SESSIONS c,REP_WIDGET_INST d
WHERE a.subject_id= c.subject_id AND a.task_type=71 AND a.task_id=b.workflow_id
AND b.task_type=68 AND b.task_id=c.session_id
AND c.mapping_id=d.mapping_id 
AND d.widget_type=80

More Information
Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:9/7/2009 4:29 AMID:107445
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)