Metadata Repository Query to Search for Truncate Table Option 

select 
   task_name,
   'Truncate Target Table' ATTR,
   decode(attr_value,1,'Yes','No') Value 
from OPB_EXTN_ATTR OEA,
     REP_ALL_TASKS RAT  
where 
      OEA.SESSION_ID=rat.TASK_ID 
      and attr_id=9

Comments

Post a Comment

Popular posts from this blog

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

Top IT certifications

Top-paying certifications The average highest paying certification categories worldwide were AWS Certified Solutions Architect-Professional ($120,136), Google Cloud Platform (GCP) Cloud Architect ($118,756), and CISSP ($116,573).  The report also listed the top-paying certification in each region. Here are the top five. North America GCP Cloud Architect ($152,129)  CISM ($132,919) Certified ScrumMaster ($132,903) AWS Certified Solutions Architect - Associate ($130,883)  AWS Certified SysOps Administrator - Associate ($130,610)  Latin America  TOGAF 9.1 ($74,646)  Six Sigma Green Belt ($71,532)  Project Management Professional ($63,064)  CCIE Routing and Switching ($57,685)  CISSP ($57,168) Europe, the Middle East, and Africa (EMEA)  GCP Cloud Architect ($103,448)  TOGAF 9.1 ($99,402) GCP Data Engineer ($97,175)  CISSP ($95,340)  PRINCE2 Practitioner ($87,987) Asia-Pacific   TOGAF ...
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