1 Reply Latest reply on Mar 30, 2020 9:22 PM by Syed Aziz

    Repository Query for Rank Transformation

    Rajesh Kumar Selvakumar New Member

      I have 300+ mappings in my folder and need to identify about the ports in Rank transformations.

       

      But the ports which is enabled "Group By"  and the port is R enabled.

       

      I need to retrieve through the repository query. This is the below given query to identify the ports, but I cant find the attributes of Grouped By port and R (Rank Port is enabled)

       

      select

           A.*,B.*,C.*

      from

             REPOFDSPROD.REP_WIDGET_FIELD a

           , REPOFDSPROD.REP_widget_inst  b

           , REPOFDSPROD.REP_all_mappings c

      where

             a.widget_id         =b.widget_id

             and b.widget_type   =26

             and b.mapping_id    =c.mapping_id

       

       

      Can anyone help on this?

        • 1. Re: Repository Query for Rank Transformation
          Syed Aziz Guru

          Hello Rajesh,

           

          The Rank cache information can be obtained from the REP_WIDGET_ATTR view. The widget_type for the Rank transformation is 26: REP_WIDGET_ATTR.widget_type = 26.

           

           

          The following query returns the Rank 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,6,'data_cache',7,'index_cache', 1,'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 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_id=e.widget_id

          AND d.widget_type=26 AND e.widget_type=26 AND e.attr_id IN (1,6,7)

          ORDER BY 1,2,3,4,5,6

           

          Thank you,

          Syed