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

HOW TO: Find the Joiner cache size and directory information in a repository
Answer
The Joiner cache information can be obtained from the REP_WIDGET_ATTR view, and widget_type for the Joiner transformation is 12: REP_WIDGET_ATTR.widget_type = 12

The following query returns the Joiner cache information with associated folders, workflows, sessions, mappings, and transformations:

SELECT c.subject_area folder_name,a.task_name workflow_name,b.instance_name session_name, c.mapping_name,
d.instance_name transformation_name, DECODE(e.attr_id,10,'data_cache',11,'index_cache',2,'cache_directory') cache_type,
e.attr_value
FROM REP_ALL_TASKS a,REP_TASK_INST b,REP_LOAD_SESSIONS c,REP_WIDGET_INST d, REP_WIDGET_ATTR e
WHERE c.subject_id=a.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_id=e.widget_id
AND d.widget_type=12 AND e.widget_type=12 AND e.attr_id IN (10,11,2) 
ORDER BY 1,2,3,4,5,6


More Information
Note

This query will only show the settings defined at mapping level.
These are statements just to retrieve the cache information. Do not update any repository table, without consulting Informatica Customer Support.


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

Reference
"Using Metadata Exchange (MX) Views" in the PowerCenter Repository Guide

Attachments

Last Modified Date:4/20/2012 4:02 AMID:105583
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)