Repository tables Expression query

Repository tables Expression query



In a mapping with multiple expression transformations and multiple unconnected lookups, it is difficult for you to identify the expressions calling these unconnected lookups. This SQL will give you what you are looking for.

select w.instance_name,
       g.expression
from opb_widget_expr f,
     opb_expression g,
     opb_widget_inst w,
     opb_mapping m
where f.expr_id = g.expr_id
and f.widget_id = w.widget_id
and w.widget_type = 5
and w.mapping_id = m.mapping_id
and m.mapping_name = <mapping_name>

Comments

Post a Comment

Popular posts from this blog

Data Center Technician / Engineer certifications

Cisco Certified Network Associate Data Center (CCNA Data Center) Cisco Certified Network Professional Data Center ( CCNP Data Center ) Juniper Networks Certified Professional Data Center (JNCIP-DC) VCE Converged Infrastructure Administration Engineer (VCE-CIAE) VMware Certified Professional 6 – Data Center Virtualization (VCP6-DCV)
Read more

Industry 4.0 IOT

The Industrial Internet of Things (iIoT), which is also known as  Industry 4.0  when applied to the manufacturing industry, is a concept of integrating smart manufacturing machinery, AI-powered automation, and advanced analytics to help make every worker and every factory more efficient. The iIoT will revolutionize manufacturing by enabling the acquisition and accessibility of far greater amounts of data both faster and more efficiently than ever before. Many manufacturers have already started to implement the IIoT devices and processes by leveraging intelligent, connected devices inside their factories, warehouses, and workshops. In most cases, companies are deploying iIoT devices and machinery that are connected by communication technologies that assist industries in collecting, monitoring, analyzing, and delivering valuable insights like never before. The exact mechanics of how this technology is deployed varies from company to company, but the goal is always the same; to i...
Read more

different OPB tables

OPB_SUBJECT - PowerCenter folders table OPB_MAPPING - Mappings table OPB_TASK - Tasks table like sessions, workflow etc TASK_TYPE for session is 68 and that of the workflow is 71. OPB_SESSION - Session & Mapping linkage table OPB_TASK_ATT R - Task attributes tables OPB_WIDGET - Transformations table Usage: Use WIDGET_ID from this table to that of the WIDGET_ID of any of the tables to know the transformation name and the folder details. Use this table in conjunction with OPB_WIDGET_ATTR or OPB_WIDGET_EXPR to know more about each transformation etc. OPB_WIDGET_FIEL D - Transformation ports table Usage: Take the FIELD_ID from this table and match it against the FIELD_ID of any of the tables like OPB_WIDGET_DEP and you can get the corresponding information. OPB_WIDGET_ATTR - Transformation properties table Usage: Use the ATTR_ID of this table to that of the ATTR_ID of OPB_ATTR table to find what each attribute in this transformation means. OPB_EXPRESSION - Expressions table Usa...
Read more