3.22 Optimizing the Source and other Transformations
Optimizing the Source Optimizing the Query: Single table select statements with an ORDER BY or GROUP BY clause may benefit from optimization such as adding indexes Using Conditional Filters: if multiple sessions read from the same source simultaneously, the Powercenter conditional filter may improve performance Increasing Database Network Packet Size in Oracle (listener.ora and tnsnames.ora) […]
3.21 Optimizing Flat File Sources
If each line in the source file is less than the default setting (1024 Bytes per line), you can decrease the line sequential buffer length in the session properties Configuring Single-Pass Reading: Consider using single-pass reading if you have multiple sessions that use the same sources Optimizing Filters: Use Filter Conditions as early in the […]
3.20 Optimizing Flat File Targets
If you use a shared storage directory for flat file targets, ensure that the shared storage directory is on a machine that is dedicated to storing and managing files, instead of performing other tasks Drop Indexes and Key Constraints before running the session Use constraint-based loading only if necessary Increasing Database Checkpoint Intervals Using Bulk […]
1.02 Repository Level Queries
2.1 List of “Not Valid” objects in a Repository SELECT REPOSITORY,FOLDER_NAME,WORKFLOW_OR_WORKLET,TASK_TYPE, WORKLET_OR_SESSION,IS_VALID FROM (SELECT DISTINCT OPB_REPOSIT_INFO.REPOSITORY_NAME AS REPOSITORY, OPB_SUBJECT.SUBJ_NAME AS FOLDER_NAME, OPB_TASK.TASK_NAME AS WORKFLOW_OR_WORKLET, DECODE(OPB_TASK_INST.TASK_TYPE,58,‘COMMAND’,59,‘DECISION’,60,‘EVENT WAIT’,62,‘START’,65,‘EMAIL’,66,‘TIMER’,67,‘ASSIGNMENT’,68,‘SESSION’,70,‘WORKLET’,91,‘CONTROL’,NULL) TASK_TYPE, OPB_TASK_INST.INSTANCE_NAME AS WORKLET_OR_SESSION, DECODE (OPB_TASK_INST.IS_VALID,1,‘VALID’,‘NOT VALID’) AS IS_VALID FROM OPB_TASK_INST,OPB_OBJECT_TYPE,OPB_TASK,OPB_SUBJECT,OPB_REPOSIT_INFO WHERE OPB_TASK_INST.TASK_TYPE != 62 AND OPB_TASK_INST.TASK_TYPE = OPB_OBJECT_TYPE.OBJECT_TYPE_ID AND OPB_TASK_INST.WORKFLOW_ID = OPB_TASK.TASK_ID AND OPB_TASK_INST.VERSION_NUMBER = OPB_TASK.VERSION_NUMBER AND OPB_TASK.SUBJECT_ID = OPB_SUBJECT.SUBJ_ID AND OPB_TASK.UTC_CHECKIN 0 ) WHERE IS_VALID = ‘NOT VALID’ ORDER BY 2,3 2.2 Check Reposit DB User and Type SELECT REPOSITORY_ID, REPOSITORY_NAME, DATABASE_USER, DECODE (REPOSITORY_TYPE,1,’GLOBAL’,2,’STANDALONE’,3,’LOCAL’) REPOSITORY_TYPE FROM REP_REPOSIT_INFO order by 2 2.3 List where […]