✍ Kashif M
Trends

Sunday, 6 September 2015


Query related to mapplets in Informatica


By on September 06, 2015


7.1           List Mapplets in all folders


 select subject_area,mapplet_name from rep_all_mapplets
order by 1,2

Informatica
Informatica

7.2           List Mapplet parameters and variables

select distinct rep_reposit_info.repository_name, rep_all_mapplets.subject_area
as folder_name, rep_all_mapplets.mapplet_name as object_name,
case when opb_map_parmvar.pv_flag = 2 then 'Mapplet Parameter' else
case when opb_map_parmvar.pv_flag = 3 then 'Mapplet Variable' end
end as parameter_type, opb_map_parmvar.pv_name as parameter_name,
opb_map_parmvar.pv_default as parameter_value,
opb_map_parmvar.pv_desc as description
from rep_all_mapplets, rep_widget_inst, opb_mapping, opb_map_parmvar, rep_reposit_info
where rep_all_mapplets.mapplet_id=opb_mapping.mapping_id
and rep_widget_inst.widget_id=opb_mapping.ref_widget_id
and opb_mapping.mapping_id=opb_map_parmvar.mapping_id

and rep_widget_inst.widget_type=44

Kashif
mkashu: Query related to mapplets in Informatica
Review : Kashif | Kashif
Update: September 06, 2015 | Rating: 4.5

Comment for "Query related to mapplets in Informatica"

0 comments

Post a Comment

Blog Archive